Access Closed workbooks (2003)
I am trying to pull information from a multiple of workbooks. I would like
to put the reference name (path,file name ,sheet name and lcell ocation) in separate cells so I can easily change from where I am pulling data. (eg I get a set of workbooks each month from which I want to aggregate the data. I can use the vlookup function which will pull from a closed file but I have to manually alter each formula for the new report name each month. I've tried the indirect function with the concatenate function (to put the pieces together) but this only works when all the files are open. Thanks |
Access Closed workbooks (2003)
Maybe this will help
http://www.rondebruin.nl/summary2.htm -- Regards Ron de Bruin http://www.rondebruin.nl "jmack" wrote in message ... I am trying to pull information from a multiple of workbooks. I would like to put the reference name (path,file name ,sheet name and lcell ocation) in separate cells so I can easily change from where I am pulling data. (eg I get a set of workbooks each month from which I want to aggregate the data. I can use the vlookup function which will pull from a closed file but I have to manually alter each formula for the new report name each month. I've tried the indirect function with the concatenate function (to put the pieces together) but this only works when all the files are open. Thanks |
Access Closed workbooks (2003)
Thanks for the tip. Is there anyway this with formulas? It was easy to do
in Lotus (years ago). "Ron de Bruin" wrote: Maybe this will help http://www.rondebruin.nl/summary2.htm -- Regards Ron de Bruin http://www.rondebruin.nl "jmack" wrote in message ... I am trying to pull information from a multiple of workbooks. I would like to put the reference name (path,file name ,sheet name and lcell ocation) in separate cells so I can easily change from where I am pulling data. (eg I get a set of workbooks each month from which I want to aggregate the data. I can use the vlookup function which will pull from a closed file but I have to manually alter each formula for the new report name each month. I've tried the indirect function with the concatenate function (to put the pieces together) but this only works when all the files are open. Thanks |
Access Closed workbooks (2003)
There is a pull function from Harlan Grove that you can try
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 "jmack" wrote in message ... Thanks for the tip. Is there anyway this with formulas? It was easy to do in Lotus (years ago). "Ron de Bruin" wrote: Maybe this will help http://www.rondebruin.nl/summary2.htm -- Regards Ron de Bruin http://www.rondebruin.nl "jmack" wrote in message ... I am trying to pull information from a multiple of workbooks. I would like to put the reference name (path,file name ,sheet name and lcell ocation) in separate cells so I can easily change from where I am pulling data. (eg I get a set of workbooks each month from which I want to aggregate the data. I can use the vlookup function which will pull from a closed file but I have to manually alter each formula for the new report name each month. I've tried the indirect function with the concatenate function (to put the pieces together) but this only works when all the files are open. Thanks |
All times are GMT +1. The time now is 11:56 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com