Hi!

The only way to do what you want requires that each of those files be open.
You don't want all those files to be open do you?

Biff

"singlgl1" wrote in
message ...

I'm trying to fill the same formula (links) down a column on a
worksheet.
I'm linking from the same cell from a months worth of files,only the
file reference is changing as shown below.(11-1-05,11-2-05,etc..)

Cell A1='C:\Reports\Nov\[11-1-05.xls]Production'!$Z$1
CellA2='C:\Reports\Nov\[11-2-05.xls]Production'!$Z$1
CellA3 ='C:\Reports\Nov\[11-3-05.xls]Production'!$Z$1

Thanks, Greg


--
singlgl1
------------------------------------------------------------------------
singlgl1's Profile:
http://www.excelforum.com/member.php...o&userid=26389
View this thread: http://www.excelforum.com/showthread...hreadid=478606