populate table based on drop down selection

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

Originally Posted by alansidman

Create a Pivot Table as shown in attached.

Pivot table is not what I need here. I want to have all columns and related rows to be shown/copied from the source table to the new table based on the selection, not any sums and group by as in pivot.

Thanks

this looks really good, still don't understand it fully, but have to spend bit more time on it
However, is there a way to correct the filter in sheet1!B1? It's a dropdown list from Pivot table, which could be changing, so the list should always show new entries as well except emtpy lines and "Grand Total" value.

Thanks

Originally Posted by FDibbins

If you can do without the PT, you can create your own list of unique customers on sheet2 with the same thing on sheet2, copied down...
=IFERROR(INDEX($A$2:$A$30,MATCH(0,INDEX(COUNTIF($F$1:F1,$A$2:$A$30),0,0),0)),"")

Thanks for this one, what can I do to remove 0, always added at the end of the created list?

Attachment 240130