filter

[kwlickt]

I am a basic excel user. I am looking to find an easier way to filter data. Currently I'm working with spreadsheets that have over 22,000 rows that need filtered by the 54 locations that we serve. The location name is one of the columns in the sheet, so I filter that column and copy the data in a new sheet. Then I repeat the process 53 times so that each location is in its own sheet. There must be an easier way to filter data from one sheet to another. Can anyone help?



Keith

[Kimberly]

I wonder why you need each location displayed on a seperate sheet, but you can use the VLOOKUP function.

Either move the Location column so it is the first column, or make a formula to display the Location in the first column.
In each of the other sheets, put a location in A1.
Group the 54 Location sheets and use this formula in cell B2 (I assumed the data was on Sheet1, A1:H22000):
=VLOOKUP($A$1,Sheet1!$A$1:$H$22000,2,0)
copy across however many columns you have, but each time change the 2 (the third argument) to the next number (3, then 4, then 5, etc)
Ungroup the sheets.