N Nic New Member Mar 20, 2013 #1 Can you have a Named Table within a table that expands with the mother table? Or do you have to do this with dynamic named ranges. Thanks Nic
Can you have a Named Table within a table that expands with the mother table? Or do you have to do this with dynamic named ranges. Thanks Nic
Hui Excel Ninja Staff member Mar 20, 2013 #2 Nic Tables are special Named Formula that Excel sets up and manages You can see them in the Named Formula Manager, but can't overide/edit them I think you'd have to use a Named Formula (Dynamic Range) to select a Subset of a Table, unless Filtering is applicable
Nic Tables are special Named Formula that Excel sets up and manages You can see them in the Named Formula Manager, but can't overide/edit them I think you'd have to use a Named Formula (Dynamic Range) to select a Subset of a Table, unless Filtering is applicable
