Filter multiple tabs at the same time

[ZahinOsman]

Hi Guys,

Was wondering if it was possible to filter multiple tabs at the same time? (Same schema/format)

Eg. 

Example of the type of data found in these 3 tabs;

PaymentDate	FixingRate	FlowType	FlowSubType	Currency
2024-11-13	1	Payment	Exchange	USD
2024-11-15	2	Interest	Interest	USD
2025-02-18	3	Payment	Projected	USD
2025-05-15	3	Interest	Projected	USD
2025-08-15	2	Payment	Projected	USD

What if i wanted to filter for only FlowType = Payment, but filter all 3 tabs at the same time? Is it possible? So far have not seen any solutions regarding this

[flying008]

Hi, @ZahinOsman 

Maybe you can use batch macro or Dynamic input tool to input the data of 3 sheets at once, then filter by [FlowType].

[nagakavyasri · Accepted solution]

@ZahinOsman