|Date:||Thu, 25 May 2006|
I create a monthly profit&loss file that after each month, I do a file SAVE
AS to create next months file copy, etc.
In the file, a Profit & loss sheet refers back to the same month of last
year. How do I create a reference so the when I create the SAVE AS file, it
looks back at the same month.
Right now, i have to go into each cell and change the file look back name...
How do I have the [043005.xls] change to [053105.xls] when I create the new