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
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