Filtering multiple sheets of data

[stvbrown2184]

I have around 100 sheets of data, I need to be able to use the filter function (under the Data tab) to filter all the sheets at once. Anyone know how to do this?

[oeldere]

I bet there is another question hidden (so what is the goal you want to achieve)?

[stvbrown2184]

my file is too big too attach so I am going to make it smaller and upload it, so you can see what I am talking about.

[powdow]

Here is doe to advance filter on criteria that is on sheet1, the same criteria applies to all sheets.

Please Login or Register  to view this content.

[stvbrown2184]

11906vxlforum.xlsx

attached if the shortened version of the file (so it as under 1 GB)

with the exception of sheet "singles" I need all the sheets to like like sheet "1052".

on sheet 1052, I have filtered column G by going to Data, Filter, Number filters, greater than 1... I would like to filter all the sheets on the file like this.

[AB33]

Assuming there is no complete blank row or column, this works fast.

Please Login or Register  to view this content.

[stvbrown2184]

AB33,

Thats a bit over my head. Where do I insert that code?