Filter Data on Multiple Tabs based on Selected Data

**MAshleigh** · 02-10-2012, 08:56 PM

Hi,
I am by no means an excel expert but I have a problem that I will likely lose sleep over until I find a solution.

I have a workbook with 4 tabs of data - each tab is set up the same with the same column headers.

I want to create a tab that will essentially search the other tabs and return rows of data based on criteria specified be selecting an option in a drop down menu. I have tried using the VLOOKUP function however I think this is too complex a situation for it. Pivot tables won't work either because I'm not trying to analze the data - I am simply trying to filter/seach the data and return all the information in a row as is. Essentially i need to autopopulate a table based on selected criteria.

How do I do this?

Thank you!

MRA

**dangelor** · 02-10-2012, 09:20 PM

Try using Advanced Filtler.

**MAshleigh** · 02-16-2012, 10:01 AM

Can you do advanced filter over multiple spreadsheets of data?

I was thinking of something a bit more user friendly as this workbook will need to be used by made people.

I was hoping to have something dynamic that extracts data based on simply selecting from a drop -down menu. Would this require VBA?

1. There are 4 tabs with data - same column headers on each. They all look like this:

Data tab example..jpg

2. Data Validation tab 'X' - this is the information I want to filter by. Used for data validation in columns D, E and H on the 4 tabs with data. I also want to filter information on the new tab using this data.
[ATTACH]141703[ATTACH]

Does this help?

**MAshleigh** · 02-16-2012, 10:09 AM

Data Validation tab - 5..jpg

This is the Data Validation tab

**dangelor** · 02-16-2012, 01:17 PM

The pictures aren't much help - too small to see any detail. Suggest you attach a copy of the workbook, if possible, or at the least a mock-up version with dummy data...