Filter two or more sheets with 1 action

[ivaylos89]

Hey, folks,

I have an Excel file with 5 sheets.

The second sheet (let's call it "B") has several columns. Column B is called ID.
The third sheet (let's call it "C") also has several columns and column B is called ID.

Both ID columns contain the same values but the rest contain different info.

I'm applying a filter to the ID column of sheet "B". Let's say the value is "A1234"
I'm doing the same thing in sheet "C".

Regrettably, I can't add screenshots. Please check my signature.

Is there a way to do the above with 1 action instead of 2?

[TMS]

we don't want screenshots, we want a sample file.

Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.

[ivaylos89]

Financial Sample.xlsx

Here is the file. As you can see in sheet A, I have filtered the country column by 'Canada'.
What I want to achieve is to automatically filter the country column in sheet B, when I change it in sheet A.

So when I select Canada in Sheet A, I want Canada to be filtered in sheet B.

[TMS]

Pretty sure you'd need VBA for what you are asking.

You could perhaps have a separate drop down box to select the country. Then use a Worksheet Change Event handler to monitor the drop down and filter both tables.

I don't think you can do it natively.

Do you need or have to have the data in two tables?

Or, you could have a drop down for the countries and use FILTER on each of the tables and output to a third sheet - not quite combined but side by side. That wouldn't need VBA.