Forum Discussion
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, ...
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
- Thank 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.
- What 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.
