Dynamic Named Range repeat on different worksheet
Howdy
I've got a dynamic named range (usually 4 columns x 50 rows) created using
the offset formula and some other named cells for variables, and ideally
want to show the resultant range on another worksheet, including allowing
the repeat of the range to expand (or contract) vertically and horizontally.
I'm not sure what this is called, maybe if I knew this I could figure it
out...
Any help greatly appreciated.
Cheers
Matt
|