Create small table from named range in larger table

[chippy36]

Hi All,

This morning I managed to create a small test sheet where I created a table and then created a second table from data within the first table. Now for some reason, I can't remember how I did it and can't get it to work again.

I have a table with 2 named ranges in it, I'm trying to create a linked table based on one of the named ranges. It needs to be linked so as when prices are changed in the main table they are updated in the smaller table.

I did it this morning just using the connections in the data tab, no VBA or macros

anyone any ideas?

Thanks

 

[Fazza]

Maybe what used to be called a query table. Not sure if that name is still used.

From a saved file & normal (non-dynamic named range), ALT-D-D-N and follow the wizard to set up. Is refreshable like a pivot table.

HTH