Forum Discussion
Create a link between two Excel files
Hello! I am currently working with several Excel files to process payments to volunteers in our company. A colleague who doesn't work in my company anymore has created two files which are linke...
hey! Thanks for your quick response. I just created a new file based on the data_volunteers one so I could delete the data and upload to OneDrive. The file is actually called data_volunteers when I'm working with it so that's not the problem!
I've taken a few minutes to write a different formula altogether that can pull the data without a macro.
The basic formula is this FILTER formula. You'll need to adjust the first references to the appropriate column in the data_volunteers sheet. This formula retrieves the Address data, from column L in the source file. I adjusted it in a few other columns just to verify its efficacy. Did not copy to all of them, so some of the original formulas remain.
=FILTER([data_volunteers.xlsm]Sheet1!L$2:L$18,[data_volunteers.xlsm]Sheet1!$B$2:$B$18=$B2)
I'm leaving home now for the rest of the working day....so won't be able to answer any questions for the next 8 hours or so.