Forum Discussion
djessfernandez
May 24, 2021Copper Contributor
Can I link excel data to another workbook based on certain criteria?
Hello, I am using Windows 10 Pro. I have a main sheet that has one column of information(column A) that needs to be linked to another document. I cannot simply just link the entire column, ...
mathetes
May 24, 2021Silver Contributor
If you have the newest version of Excel, the FILTER function will do what you are seeking. I've attached two files, one is your original with a FILTER function on the same sheet as your data. The other (Part Two) shows how a separate workbook altogether can bring in the desired data.
Here's a YouTube video that does an excellent job of explaining FILTER. https://www.youtube.com/watch?v=9I9DtFOVPIg
- djessfernandezMay 24, 2021Copper ContributorThank you, this has brought me one step closer. I watched the video but a bit stuck on linking the sheets through the filtering- did you use the built in function in excel? I am using it but returning error.
- mathetesMay 24, 2021Silver ContributorWhat version of Excel do you have? In order for FILTER to work, you need to have the most recent version.
Yes, I used the built-in function. You should be able to see the formulas/functions in the two sample files I sent back.- djessfernandezMay 24, 2021Copper Contributor