Hide rows not matching criteria

Hello, I have a file with various rows and I'd like to hide any rows that do not match certain criteria in column A. Each row has a different type of merchandise listed in column A (ex: blankets, brooms, etc). So for example, if I wanted to see all "broom", "luggage", and "furniture" rows, all other rows should be hidden. I have to do this in Excel 2003 (I know that Excel 2007 allows users to filter by checking off various criteria, yet 2003 only lets users pick from 2 criteria choices).

I am hoping there is a formula that will be able to do this, perhaps with me typing a list of criteria in a new tab. I would need to apply the same filtering to a new file each week (row positions will change), yet the criteria of interest will always remain the same.

Alternatively, there may be a macro that can hide unwanted rows. I am open to trying this, yet am not very familiar with macro coding and can't see to get the VB Add-In menu to come up on my screen.

Another possible option would be to link the spreadsheet to an Access database and then preform a 'select query' to return only the desired rows...I will be able to figure this out myself if necessary.

I have attached a sample file ... thank you for any assistance!

Shell

You could set up an Advanced Filter to do this. Look at the Help or Google examples.


Regards, TMS

You're welcome. Thanks for the rep.