Copying multiple named ranges onto a Consolidation worksheet
Posted on 2013-10-24
I have dynamic named ranges in multiple sheets. How can I consolidate all the named ranges together into another sheet?
What I'm trying to replicate is as if I would manually select a named range, copy it, paste its values only into another sheet. Repeat for second range, but insert it Under the pasted range #1, etc.
The problem is I want this to be automatic (without clicking a button, etc.) and don't forget the named ranges are dynamic, so I will be inserting/deleting rows in named ranges here and there, and this needs to be reflected correctly in the consolidated range.
I don't need data validation between ranges.
How can I do this ?