I need to determine how to filter a tab based on criteria selected from another tab. I know hoe this would be done in Access vb but cannot figure out how to do in excel.
I've attached an example spreadsheet - seletions are made in the the first tab via drop down lists and radio buttons. I want the second tab to filter based on the selections in the first tab.
Any help is greatly appreciated - thanks!
Bookmarks