Filter specific rows in a table?

[webehighrollin]

Hello,

I have a spreadsheet with about 500 tables (each table is 9 rows by 12 columns). On each table, on row 3 column 1, there is an identifier for each table (i.e: technology, manufacturing, infrastructure..etc.).

Is there anyway possible for me to create a filter for each of these tables, where I can select, technology, and every table that has to with technology show up?

[Richard Buttrey]

Are these 500 (!) tables all on the same sheet, lined up underneath each other and using the same 12 columns? If so just select the whole of column 1 and filter it for your identifier

If they are not lined up as above then with that number of tables you'll either have to resort to macros or line them up.

I'd suggest however that you redesign your data and create one big table with 500*9 rows and include an extra thirteenth column which will contain a reference to the table. e.g. 'Table1', 'Table2'......'Table500'

Then you can easily filter by table/identifier and indeed the whole world of pivot tables is then open to you.

Regards