Hi David
The indirect formula is not working with closed workbooks
But you can try this
http://www.rondebruin.nl/summary2.htm
Harlan Grove wrote a UDF called PULL that will retrieve the value from a closed
workbook.
You can find the function at Harlan's FTP site:
ftp://members.aol.com/hrlngrv/
Look for pull.zip
--
Regards Ron de Bruin
http://www.rondebruin.nl
"David Clark" wrote in message ...
I would like to write a formula to extract data from a series of workbooks
whose filenames vary by month ie datajan05.xls, datafeb05.xls, etc.
I would like to write the formual so it copies the month from the top of the
column to create the file name ie =data[a1].xls . This would enable me then
to copy across the page rather than having to edit every cell formula.
Can anyone help? Thanks.