Saving data with macro

[legepe]

I have a base spreadsheet program. Once data has been processed an
results taken, I need to clear all data inputted for period, but befor
clearing i need to save a copy of it showing the results.
Can any one tell me how i can do this using macros
Thanks
legep

 

[Dale Hymel]

I have a base spreadsheet program. Once data has been processed and
results taken, I need to clear all data inputted for period, but before
clearing i need to save a copy of it showing the results.
Can any one tell me how i can do this using macros
Thanks
legepe