Cell lookup

Giganews Newsgroups
Subject: Cell lookup
Posted by:  dwoloszyk
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...

i.e.='\easfs\MonthendCorp\2005\[043005.xls]ConsYTD'!$B$6

How do I have the [043005.xls] change to [053105.xls] when I create the new
file?

Replies