Filter out rows iteratively?

[Access9001]

I want to be able to go down my rows and, with VBA, filter out any number of arbitrary rows. I'm not looking into hiding rows but rather filtering them so I can always turn them back on later with .ShowAllData.. Is this doable?

 

[Access9001]

Alright, I will look into another way. Thank you.