Creating a table based on a table in another sheet

[kwjoh]

Hello,

I have tried searching for this since I am surely not the first person to need this. I am trying to create a table on a sheet based on a criteria in a "master" table from another sheet. In the attached table, I want to make the auto table sheet populate with any rows where the type is UDA (2 and 4 in the example). The actual use of this will be for a table with a few thousand rows that changes, which is why I want something that will auto update.

Thanks!example.xlsx

[mikeTRON]

I would create a pivot table with a filter on UDA which should give you exactly what you want.

See attached example.

example.xlsx

[kwjoh]

That is much easier, guess I was over complicating the idea. Thanks!