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?
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
Richard Buttrey
If this was useful then please rate it appropriately.
Click the small star iconat the bottom left of my post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks