Filter results based on selection ticked

[ajhickin]

Hi,

I am trying to get a set of results which are filtered based on the selection entered.

I have a spreadsheet with a list of stock items etc, and these can be duplicated because they can be in different stores. I want to be able to filter my results based on the selection of stores

So in cell A1 I would have the stock item name and for instance, A2 through to A10 could be the different stores where that item is available. For example, A1 Engine, A2 Birmingham, A3 London, A4 Manchester, A5 Dundee and so on

At the top of my spreadsheet I want to have a tickbox for each store so that my results would show me all of the stock in all the stores I have ticked.

Is there any way of setting this up?

Thanks
Andy