May 24 2021 07:31 AM - edited May 24 2021 07:35 AM
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.
May 24 2021 07:44 AM
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
May 24 2021 09:06 AM
May 24 2021 09:57 AM
May 24 2021 12:57 PM