I want to have a worksheet automatically be populated with the name and several bits of data from other workbooks in a particular folder.
I can get the names to be entered using the INDEX function but currently need to manually edit the path statements to get the extra bits of data.
I cant use the INDIRECT function as the files are closed... and it seems that I cant use INDIRECT.EXT as I am using Excel 2013 64 bit.
Any suggestions ?
Many Thanks
Andrew
I have used INDIRECT.EXT on 2013. There is an additional file that you need to download... I think. However, you can use a UDF to do this for you.
Here's a fairly self-explanatory pair of files with it in use. You'll need to adjust the path for the PULL function from C:\Users\Windows 8\Desktop\ - which is what I'm using to whatever you have. Keep Source closed and open PULL Lookup.
Please Login or Register to view this content.
Enable macros on opening PULL Lookup....
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Hi Glenn .. fantastic .. had not used PULL before and fiddled with you answer and its working like a dream .. really appreciate the help
Hi Andrew,
Take a look at Power Query (called Get & Transform in 2016) as it was built to pull in all different kinds of data into Excel. You should update your profile so we know what version of Excel you have.
One test is worth a thousand opinions.
It is useful. I copied it from someone else, but I can't remember who it was. So apologies for not acknowledging you.... whoever you are...
PULL compliments of Harlan Grove.
Pull
I learned a lot of what I know from Harlan. A true GURU if there ever was one!
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Thanks, Tony!!
----------
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks