save file macro

[philthedil]

I have a worksheet that i use to do a report .When i do the repor
sometimes i forget to save a copy .When i do another report i delet
some data and add new data the old data for another report.

Is there a macro that will save a copy of my origanal worksheet so
dont lose data if i forget to save it .thanks phi

 

[JulieD]

Hi

i would look at making the workbook a template, then every time you need to
do a report you choose file / new ... find your template and then enter the
new data etc ... this way you can never type over the old data.

to create a template, save the existing workbook using file / save as and
choose under files of type - template, give it an appropriate name and click
the save button.

hope this helps
Cheers
JulieD