Hi all,

I'm developing a product/cost tracker, and want to be able to display the data, at a high, in a table based on filtered list. I have the graphs and small table on one sheet, and the raw data on a second.

I've already managed to get the raw data to filter (using a macro) based on individual results, but what do I need to include in the drop down list to enable me to view all the data?

So if I wanted to filter based on the Product Category: A, B, C, D, and E - I've got these in my drop down list and the macro works fine, but what if I wanted to show All Categories? What would I include in the drop down list to enable this?

Thanks,

Fi