Hi guys,

I have a data table in sheet2 (in real, it's created from DB (MS query / other sources), so the line count is changing).
I would like populate table1 @sheet1, based on selected value in the filter in sheet1

How can I achieve this?

excel_filter.xlsx


Thanks