Hi,
I have finished what I considered a "base case" for a financial projection. I'd like to compare to an "optimized case." Ideally this case would run below the base case. So each line would have an entry for base and just below the entry for optimized. All formulas, cell references run the same in the optimized but there are cells that have to be manually input. It's these manual entry cells that would change base vs. optimized. Is there a way, ie. macro to to duplicate the entire project to the row below. Can it copy all formulas, cell references, etc. but duplicate them to the optimized case below?
Thanks!
B
I have finished what I considered a "base case" for a financial projection. I'd like to compare to an "optimized case." Ideally this case would run below the base case. So each line would have an entry for base and just below the entry for optimized. All formulas, cell references run the same in the optimized but there are cells that have to be manually input. It's these manual entry cells that would change base vs. optimized. Is there a way, ie. macro to to duplicate the entire project to the row below. Can it copy all formulas, cell references, etc. but duplicate them to the optimized case below?
Thanks!
B