BiggusDoggus
Board Regular
- Joined
- Jul 7, 2014
- Messages
- 91
- Office Version
- 365
- Platform
- Windows
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?
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?
Last edited: