Quote:
Originally Posted by Fuzz
The simplest form of this is to open both workbooks, click the cell you want the data in, enter = then click the cell the data is in on the other workbook. Excel will link to the file path, you have to close the source workbook to see this. If needed you can edit this formula to use your lookup columns.
It will look something like this
='C:\data\files\[Master samples.xlsx]Sheet1'!$C$14
|
There's 2000+ rows... no thanks.
Quote:
Originally Posted by Northendzone
^ you could likely make the formula an indirect reference and then copy the formula down to work with each individual file.
if you do it this way and someone moves the files your formulas will no longer work
|
I've gotten it down to making a formula through CONCATENATE, but then it's a text string and doesn't evaluate. I've tried the macros found on google to evaluate but they don't seem to work.
I can't figure out how INDIRECT works even after reading the help.