Hi

I have a spreadsheet which links to information in another spreadsheet.

example ='c:\production\reports\jan\[jan 010107.xls]production'!$a$1

The column is filled using the same formula but different spreadsheet
filename. Each cell is a different date filename.

example ='c:\production\reports\jan\[jan 020107.xls]production'!$a$1
example ='c:\production\reports\jan\[jan 030107.xls]production'!$a$1
etc.... until the end of the month

Is there a way i can use the autofill and increment the filename instead of
manually changing the date for each day? I have to do this for every month.
At the moment i autofill the formula and go back and change the date.

Thanks