I would like to remove rows from a table which do not refer to my drop down selection - ie if I select all, I want to show All data, if I select a region, I want to show data just for that region & remove all else. I have multiple dropdowns. I have to work in Excel 2003
Bookmarks