need help displaying desired rows based on Yes and No question for multiple categories

[DixieDoll11]

I am working on a project that lists all the tasks to be completed within that project (100% display), but if some categories do not apply, I do not wish to see them in the list of tasks to be completed. I only want to see the tasks needed for that project (and the headers). On one tab, it would ask specific yes or no questions and on the other tab, I would like to see the Yes tasks listed. How can I do this?

I have an example attached - just a fake one for a visual of what I am looking for...

Please help!
Thank you!!
Debbie

[ChemistB]

One solution: Requires VBA

On "Tasks" I added a formula in Col D beginning with D3
=IF(ISERROR(VLOOKUP(B3,Table1,2,FALSE)),"Yes", VLOOKUP(B3, Table1,2, FALSE))
Then selecting the entire data range, applied an autofilter.
Then I hid Column D

Right click on Tasks Tab > "View Code
and paste this code in there

Please Login or Register  to view this content.

Make changes on "Animals" and go back to "Tasks"

[DixieDoll11]

I dont understand the "selecting the entire data range, applied an autofilter" step. And I don't see how the Task tab knows to look for "Yes" on the Animals tab?

[ChemistB]

I dont understand the "selecting the entire data range, applied an autofilter" step.

On the "Tasks" sheet, your data range (after adding the formulas in Column D is B2:D20. Select that range using the mouse so it's all highlighted
Then, in Excel 2003> Menu "Data">Filter>Autofilter.
You'll see the down arrows appear next to the headers in row 2.

how the Task tab knows to look for "Yes" on the Animals tab?

The formulas we wrote in D
=IF(ISERROR(VLOOKUP(B3,Table1,2,FALSE)),"Yes", VLOOKUP(B3, Table1,2, FALSE))
Table1 is a defined named range

=Animals!$B$3:$C$6

If you are more comfortable, just use the range and change the formula to

=IF(ISERROR(VLOOKUP(B3,Animals!$B$3:$C$6, 2,FALSE)),"Yes", VLOOKUP(B3, Animals!$B$3:$C$6, 2, FALSE))

The code that I asked you to paste in the "Tasks" worksheet code resets the autofillter to look for "yes'"

[DixieDoll11]

Thank you!!! You are awesome!
Debbie