Forum Discussion
Excel Graph > New Sheet Issue
I'm using this template:
https://templates.office.com/en-us/Weight-loss-tracker-TM03458079
I'm trying to make a copy of the original sheet, into the same workbook so I can track multiple ...
Hi Melissa
I'm just running out the office for the week but had a glance at your question and from the look of the way the spreadsheet was done, it has hard coded things with Name range.
Essentially when you copy the sheet and make a new one, it is always referencing the first one so it'll cause havoc.
I don't have an immediate answer for you but if I get time in the new few days I'll see what I can do.
Some of the other folks on the forum might have a way to fix the issue.
Good luck and hafve a great weekend!
Cheers
Damien
I'm just running out the office for the week but had a glance at your question and from the look of the way the spreadsheet was done, it has hard coded things with Name range.
Essentially when you copy the sheet and make a new one, it is always referencing the first one so it'll cause havoc.
I don't have an immediate answer for you but if I get time in the new few days I'll see what I can do.
Some of the other folks on the forum might have a way to fix the issue.
Good luck and hafve a great weekend!
Cheers
Damien
Thank you, Damien.