I have the feeling I'm going about this wrong, but here's where I am:
I'm making about 100 workbooks in a folder - each with a filename of site code for each location we are working on (coded in numbers) - and another workbook each of the first workbooks needs to pull it's information from called Data Entry. The Data Entry workbook has a Column A with site codes. I need to insert data from that row into the other workbooks.
Easy, right? I'm using
=VLOOKUP("1556",[Data Entry]Sheet1!$A1:$BL$100,5,FALSE) And it works fine. I don't want to edit 100+ workbooks. Is there a way to replace "1556" with the name of the file (minus .xlsx)? Is there a better way i can do this?
It's basically a mail merge, but I need it to be dynamic.
Thanks in advance!
I'm making about 100 workbooks in a folder - each with a filename of site code for each location we are working on (coded in numbers) - and another workbook each of the first workbooks needs to pull it's information from called Data Entry. The Data Entry workbook has a Column A with site codes. I need to insert data from that row into the other workbooks.
Easy, right? I'm using
=VLOOKUP("1556",[Data Entry]Sheet1!$A1:$BL$100,5,FALSE) And it works fine. I don't want to edit 100+ workbooks. Is there a way to replace "1556" with the name of the file (minus .xlsx)? Is there a better way i can do this?
It's basically a mail merge, but I need it to be dynamic.
Thanks in advance!