Hi,
Brand new at posting to the forum but have found advice on here regularly.
Background:
I was assigned at my workplace to create an S curve generator within excel that spits out the cumulative and periodic values and percentages over a specified time period and with a specified amount of Units (this can be dollars, kwh, anything basically over time) and you choose between 3 different algebraic formulas depending on the size and scope of your project.
I have made this successfully dynamic so that the graph and the table are completely dynamic based on all my inputs, to make the graph dynamic I have named ranges mainly for simplification and have not used any macros or VBA code etc.
The problem I have run into is some colleagues would like to copy the sheet that has the chart and table on it (this has all of the inputs etc in it also no links to other sheets). Everything seems to work fine once it is copied except the named ranges are not copies. The named ranges are added to the new workbook but when I go to select data on the graph the named ranges have been replaced with the absolute cell references. I can't change it manually either. I have been working on this problem for a few hours and i'm completely stumped at this point. Any advice appreciated
Thanks.
Brand new at posting to the forum but have found advice on here regularly.
Background:
I was assigned at my workplace to create an S curve generator within excel that spits out the cumulative and periodic values and percentages over a specified time period and with a specified amount of Units (this can be dollars, kwh, anything basically over time) and you choose between 3 different algebraic formulas depending on the size and scope of your project.
I have made this successfully dynamic so that the graph and the table are completely dynamic based on all my inputs, to make the graph dynamic I have named ranges mainly for simplification and have not used any macros or VBA code etc.
The problem I have run into is some colleagues would like to copy the sheet that has the chart and table on it (this has all of the inputs etc in it also no links to other sheets). Everything seems to work fine once it is copied except the named ranges are not copies. The named ranges are added to the new workbook but when I go to select data on the graph the named ranges have been replaced with the absolute cell references. I can't change it manually either. I have been working on this problem for a few hours and i'm completely stumped at this point. Any advice appreciated
Thanks.