Find Values from Sheet2 on Sheet 1 and Hide Those Rows

So I admit, this is probably way easier than I've made it out to be, but considering I've spent most of two days trying to figure this out and have yet to do so, I have arrived here, desperately hoping someone here will take pity on me and help me out.

• I have two sheets in a file called MyFile.
• Sheet1 has a full table of data in named range "myNamedRange" - an array that spans Sheet 1 from A2:K322.
• Sheet2 has a list of data in Column A (Range A2:A85) that I need to find in Sheet1 - either directly by the column the data is most likely to be found in [in this case, Column C ( specifically Range C2:C22)] -OR- via the named range array.

GOAL: Use the list of values in Sheet2 to hide all rows on Sheet1 that match.

Is there any way to do this? VBA is acceptable. Filters are also acceptable. I just apparently don't know how to make either do what I need. I apologize in advance for the newbie question.

Please let me know if you need more information.

Thanks for helping!

You could try this on a copy of your workbook

Please Login or Register  to view this content.