Can I filter more than 1 table in a sheet?

Hi,

This is my first post.
So let me first thank you all for the service offered.

I have a sheet with several tables arranged vertically.
I want to filter all the tables in the sheet.
Is this possible and how?

Thanks

Only one autofilter per sheet.

thats not quite true, in 2007 you can select a region ,set style as a table
and each comes with its own autofilters set
so in theory you should be able to create a say less than macro that say uses cell h1 value and applies it to the first column of each table,
ah i had another go heres an example

Please Login or Register  to view this content.

Please Login or Register  to view this content.

first code will filter on field 1 of tables 1,2,3 greater or equal to than whats in cell h1
second resets each filter
this all assumes that op has excel 2007 of course

select your each of your tables (ranges) one at a time (i presume they are all the same dimensions width wise,)
then on home tab pick format as table,pick a style make sure the pop up box reflects your table if it has headers click the box
click ok.
(note tables need to be below each other as the filter is applied to rows so if they were next to each other rows would be filtered out in adjacent tables)
now the awkward thing is as you create a table its given a name say table 1 ,table 2 and so on but if you delete one say table 2 the next one will be called table 3 not table 2
but you can rename any table, if you select the whole table another tab will pop up above the design tab called table tools ,click that and you can rename the table to match that in the code.
see attached