Hi there.
Could anyone help me with merging duplicate workbooks (with multiple worksheets inside) that retain their separate calculations
Basically I have a complex excel calculator that uses data from different worksheets based off of one input worksheet. the data calculations are on another worksheet too. I'd like to add another input worksheet but the complexity of adjusting the formulas would be difficult and be impossible to retain its integrity.
So I thought that maybe it would be possible to make a duplicate file, then merge it into the original while retaining their separate calculations and not have to alter their coding.
Then I would like to make a worksheet that can display the results from both calculators. The end result is so that I can hide all the worksheets so that only calculator 1, calculator 2 and Summary tabs are shown.
How crazy is this idea and what would it take to make it work or is there a better solution?
Would greatly appreciate some assistance.
Could anyone help me with merging duplicate workbooks (with multiple worksheets inside) that retain their separate calculations
Basically I have a complex excel calculator that uses data from different worksheets based off of one input worksheet. the data calculations are on another worksheet too. I'd like to add another input worksheet but the complexity of adjusting the formulas would be difficult and be impossible to retain its integrity.
So I thought that maybe it would be possible to make a duplicate file, then merge it into the original while retaining their separate calculations and not have to alter their coding.
Then I would like to make a worksheet that can display the results from both calculators. The end result is so that I can hide all the worksheets so that only calculator 1, calculator 2 and Summary tabs are shown.
How crazy is this idea and what would it take to make it work or is there a better solution?
Would greatly appreciate some assistance.
