Filter Several Sheets Based On Another Sheet Filter

Hi All!

I have an excel file with several sheets, like the file attached, which only have 3 sheets. All the sheets have one or more columns with values in common (in the attached only one column is in common: "Number").

Today I am using simple excel Filters in the columns on every sheet and filtering manually and what I want to do is when I choose a number in the first sheet (in my example file): "Test 1", all the other sheets get filtered by the value(s) I chose.

A simple example using my attached test file: "Test_Filters.xlsx":
-----> Sheet: "Test 1"
--------> Column: Number, select value (from the drop-down list): "1"
--------> Result: "Test 2" and "Test 3", in the column: Number get filtered by value: "1" (it is as if I had selected this value from the drop-down list, if there is a way, this would be the best solution, like I do manually, but automatically )

A few more comments, the number of values in sheets: "Test 2" and "Test 3" is not fixed, they grow almost every day.

I have read several posts in this forum and others but could not find a way to do it and also, I am not an excel expert, yet.

I hope my explanation is clear, otherwise, just tell me and I try to explain it in other words!

This is my test file: Test_Filters.xlsx

Thanks for your attention and time.

Regards!

Hi VintuBr

Does the attached file work for you?

Regards
Alastair

Hi aydeegee!

Thanks a lot for your help!

That's what I was looking for, with only one question.

I was going the same way, with a macro, I was recording a macro to know what was happening behind the scenes and after apply to all sheets in the file. It's been a long time since I used VBA, so it would take some time to discover how to loop over the sheets and apply the filter.

The question I said above is if there is a way to apply the filter to all the sheets when a value is selected in the drop-down filter in the first sheet: "Test 1", so I don't have to write the value I want to filter in a cell. I am not sure if Excel works with events, something like AutoFilter's OnChange event: when one value is selected, this event is triggered. Does this exist? I will have a look to see if I can find something.

Anyway, thanks again!

Hi VintuBr

You mean something like as attached?

To see the code, right click on the tab for Test 1 and View Code

Regards
Alastair

Hi Aydeegee. I've been trying (desperately) for the past 2 days to write a simple code that will filter specific worksheets in my book based on a value i double click on in another sheet. I almost had it nailed today but it;s not working.The two examples you posted are the closest thing I've found to a solution. could you please lend a helping hand?

Hello there!

First of all thank you for you work, I have been looking for this for one day now! Could you just tell me if it is possible to filter for example number "2" and "3"? I need something like this but i am new to vba and i really do not know how to implement it!