Hello,

I wonder if you could help? I am importing data from reports
generated each day, which must be retained. The file name therefore
includes the date. To save me updating the 200+ cells with the
correct calender day, is there a way I can make this process quicker?

i.e. if this is what the foluma used to read:

=[Book1]Sheet1_01/06/08!$A$1

I want to use something like:

=[Book1]Sheet1_ "+B1+" !$A$1 // Where B1 would equal 01/06/08.

Thank you!