Can I link excel data to another workbook based on certain criteria?

%3CLINGO-SUB%20id%3D%22lingo-sub-2380851%22%20slang%3D%22en-US%22%3ECan%20I%20link%20excel%20data%20to%20another%20workbook%20based%20on%20certain%20criteria%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2380851%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20using%20Windows%2010%20Pro.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20main%20sheet%20that%20has%20one%20column%20of%20information(column%20A)%20that%20needs%20to%20be%20linked%20to%20another%20document.%20I%20cannot%20simply%20just%20link%20the%20entire%20column%2C%20since%20the%20only%20cells%20within%20that%20column%20I%20need%20are%20ones%20that%20satisfy%3A%20their%20corresponding%20column%20B%20row%20being%20greater%20than%200.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20I'm%20only%20linking%20certain%20cells%20from%20column%20A%20if%20in%20column%20B%2C%20the%20value%20is%20greater%20than%200.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20this%20at%20all%20possible%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20attached%20an%20idea%20of%20what%20the%20main%20sheet%20looks%20like-%20I%20would%20like%20to%20only%20link%20the%20locations%20that%20the%20%23%20of%20days%20are%20greater%20than%20zero%2C%20to%20a%20completely%20new%20book.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2380851%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2380906%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20I%20link%20excel%20data%20to%20another%20workbook%20based%20on%20certain%20criteria%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2380906%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1061750%22%20target%3D%22_blank%22%3E%40djessfernandez%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20have%20the%20newest%20version%20of%20Excel%2C%20the%20FILTER%20function%20will%20do%20what%20you%20are%20seeking.%20I've%20attached%20two%20files%2C%20one%20is%20your%20original%20with%20a%20FILTER%20function%20on%20the%20same%20sheet%20as%20your%20data.%20The%20other%20(Part%20Two)%20shows%20how%20a%20separate%20workbook%20altogether%20can%20bring%20in%20the%20desired%20data.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere's%20a%20YouTube%20video%20that%20does%20an%20excellent%20job%20of%20explaining%20FILTER.%20%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D9I9DtFOVPIg%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D9I9DtFOVPIg%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2381124%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20I%20link%20excel%20data%20to%20another%20workbook%20based%20on%20certain%20criteria%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2381124%22%20slang%3D%22en-US%22%3EThank%20you%2C%20this%20has%20brought%20me%20one%20step%20closer.%20I%20watched%20the%20video%20but%20a%20bit%20stuck%20on%20linking%20the%20sheets%20through%20the%20filtering-%20did%20you%20use%20the%20built%20in%20function%20in%20excel%3F%20I%20am%20using%20it%20but%20returning%20error.%3C%2FLINGO-BODY%3E
New Contributor

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, since the only cells within that column I need are ones that satisfy: their corresponding column B row being greater than 0. 

 

So I'm only linking certain cells from column A if in column B, the value is greater than 0. 

 

Is this at all possible?

 

I have attached an idea of what the main sheet looks like- I would like to only link the locations that the # of days are greater than zero, to a completely new book. 

 

Thank you.

4 Replies

@djessfernandez 

 

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

 

Learn everything about our brand-new Dynamic Arrays and how you can use them to build advanced spreadsheets. Arrays (CSE) have long been present in Excel, bu...
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.

thank you. I am using Excel 2016

 

I appreciate your help.

 

@mathetes