I want to put two of the same (attached) ammorization charts, side-by-side, in the same spreadsheet. The reason I'm doing this is to calculate and compare two completely different loans at the same time. Problem is, all the named ranges reference to the first chart when I copy a second chart next to it.
I'm thinking I can replicate this chart and put it side-by-side with the first, if I can just remove all the named ranges, and replace them with cell references and formulas that calculate within each chart independently. I just can't figure out how to do this.
Hope this makes sense. Thanks in advance!