Formulae extracting data from other spreadsheets

D

David Clark

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

Ron de Bruin

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
 
Top