Apply Auto Filter in Sheet 1 to all other sheets

[BiggusDoggus]

Hi all

I have a workbook with multiple sheets.

In Sheet 1 there is only a list of Client Managers, which I want to filter on. All the other sheets with all the data have Client Managers in column K. The number of columns in the various sheets range up to a max of AZ.

So, if I filter on "Charlie Brown" in Sheet 1, I would like all the other sheets to be automatically filtered on Charlie Brown.

From what I can tell the only way to do this is via a VBA macro, therefore, I gather, the filter is applied in Sheet 1, a button needs to then be clicked to apply the filter to the other sheets.

I am a complete beginner with regards to VBA though. And the other scripts I have found online just don't work - I don't know how to modify them to fit my needs.

I would appreciate any assistance please! Including, for example, if all the data sheets have the Client Managers in column K, does the filtered list in Sheet 1 also need to be in column K?

 

[BiggusDoggus]

Awesome - thank you!

 

[My Aswer Is This]

Glad I was able to help you.
Come back here to Mr. Excel next time you need additional assistance.

Awesome - thank you!

 

[My Aswer Is This]

Normally when users ask for such a script they want all the filtered rows copied to a new sheet so they can see the results all on one sheet.

But you did not ask for that feature.

Take care.