How to save same excel workbook in different folders as a back up

[GRAPH WITH A MACRO]

I mean, as we do the work in excel it should automatically save in another
workbook as backup copy... it should be updated as we save the workbook.

 

[Joel]

You would need to write your own macro using the before save event or on open
event. The macro would move previous saved versions do an archieve directory.

 

[Ron de Bruin]

Or use SaveCopyAs

See the VBA help