I open a spreadsheet from a template every week and save the file with a
sequential number for the week. When I open the new file #2, I require some
data from the previous weeks file #1 to be entered into the new weeks file
#2. Is it possible to write a formula into the template to automatically
bring the data forward from week 1 into week #2. I'v thought about linking
the data, but I would have to link the data from the last file saved rather
than the actual file name, can anyone tell me if this is possible & how I
would do this. Thankyou