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.

have a look in help index for INDIRECT

--
Don Guillett
SalesAid Software

"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.

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.