Storing

  • Thread starter Thread starter jamie85
  • Start date Start date
J

jamie85

After i have entered information into the spreadsheet and printed out
the statement, i would like that statement to be stored in a seperate
worksheet and the information i entered to be deleted. How can this be
done?
 
Make a copy of the worksheet, then select the cells on the original and do
Clear contents.
 
use <file><saveas...> and give the workbook a new name including for
instance a statement number or date. for example statem03022004
then close the file. The original "blank" spreadsheet will still be the
same.

regards
Bill K
 
You would want to put the year before the month before the day of
month in your filename, so that you can sort it directory properly,
you cannot depend on the modified date because you update,
you cannot depend on the creation dates stored because they
not easily seen are lost if you restore your files.
 
Back
Top