Create small table from named range in larger table

[Robert Jones]

Hi All,

This morning I managed to create a small test sheet where 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.

If you look at the attached sheet 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

 

[p45cal]

Select the named range, copy. Move to the destination, paste-special|Paste Link.

 

[Robert Jones]

Worked a treat - Thank you