I feel that there MUST be a way to do this but I just don't know how. I have a workbook with several worksheets. On the first tab there is combo box with data from the "Raw Data" tab (main table). On another tab I have a pivot table (data source is also the "Raw Data"). I want this pivot table to automatically filter based on the selection from the combo box on the first tab.

Any suggestions? I'm willing to try anything.

Thanks!