Excel VBA hide rows based on two different cell values

[Stuepef]

I have a tab within my workbook that has a list of client details and I am looking to delete the rows that don't match two different cell values. Here are the details:

The client details data is on Sheet9 Column A starting at row 5.

The cell values are Sheet1 cell C2 and Sheet10 cell A1.

I want the code to delete all rows on Sheet9 that do not match cell C2 or cell A1.

Thank you!

 

[Stuepef]

@Fluff - works awesome, thank you! @lrobbo314 - thank you as well!

 

[Fluff]

Glad we could help & thanks for the feedback

 

[Stuepef]

@Fluff - how would I change the code to just clear the contents in the rows that dont match C2 and A1? I am running into issues with formulas that use the rows that are deleted.

 

[Fluff]

Simply replace delete with clearcontents

 

[Stuepef]

thank you!