F
FlaAl
I have a complex model that uses range names and array formulas t
simplify the model. It uses multiple worksheets to do detai
calculations and another group of worksheets to summarize thos
calculations. Think of the detail calculations as a module. In th
process the model is used for, multiple modules of data need to b
combined into the same summary. For perspective, the current mode
contains 24 worksheets and 300 range names of which roughly 1/
constitute an “expansion” module. The number of these modules varies
so I need the ability to "add-on" expansion modules as required.
would like to build a "base" model that contains the fewest module
possible and another file that contains the worksheets to add to th
"base" to expand it.
The problem, copying the add-on sheets into the base model require
that the range names used be unique. Otherwise during the cop
process, the references in the copied sheets get pointed to the rang
names that exist in the "base" file. I have been using sheet specifi
range name definitions to avoid having to create unique range names
I.E. 'sheet1module1'!samerangename = 'sheet1module1'!A1:Z1 an
'sheet1module2'!samerangename = 'sheet1module2'!A1:Z1. Consider, eac
add-on would have to either A) have all the module specific range name
altered along with all the formulas referencing these range names OR B
be a separate "add-on" file created for each possible module addition
thus limiting the number of module additions. Neither is acceptabl
based on the project definition.
Without relying on external file references, how do I merge two file
and maintain the integrity of the range name definitions on th
"imported" file
simplify the model. It uses multiple worksheets to do detai
calculations and another group of worksheets to summarize thos
calculations. Think of the detail calculations as a module. In th
process the model is used for, multiple modules of data need to b
combined into the same summary. For perspective, the current mode
contains 24 worksheets and 300 range names of which roughly 1/
constitute an “expansion” module. The number of these modules varies
so I need the ability to "add-on" expansion modules as required.
would like to build a "base" model that contains the fewest module
possible and another file that contains the worksheets to add to th
"base" to expand it.
The problem, copying the add-on sheets into the base model require
that the range names used be unique. Otherwise during the cop
process, the references in the copied sheets get pointed to the rang
names that exist in the "base" file. I have been using sheet specifi
range name definitions to avoid having to create unique range names
I.E. 'sheet1module1'!samerangename = 'sheet1module1'!A1:Z1 an
'sheet1module2'!samerangename = 'sheet1module2'!A1:Z1. Consider, eac
add-on would have to either A) have all the module specific range name
altered along with all the formulas referencing these range names OR B
be a separate "add-on" file created for each possible module addition
thus limiting the number of module additions. Neither is acceptabl
based on the project definition.
Without relying on external file references, how do I merge two file
and maintain the integrity of the range name definitions on th
"imported" file