Automatically saving copies of a workbook

[dibyendu sharma]

Dear sir/madam,
I want auto save(backup) and update my data(every time when I write some thing) of my excel through VBA CODING in different excel located in different location and folder FOR EXAMPLE save my data to excel name "storage" located in D drive in new folder.(exactly to my original data ) Kindly help me out of the problem.It should triggered as soon as a new subject's data is completed and should be updated automatically by pressing a button.And at the same time the file of the stored excel should not open automatically. The excel to be copied is attached here.


Thank you
Dibyendu Sharma