The goal here is to get a template page which will be duplicated and renamed, and still have all of its charts ready to work without changing any data settings. However, when I create new copies, the graphs continue reading data from the original document.
The INDIRECT command has been helpful, but whenever I try to use it, Excel automatically puts the name of the current sheet in next to it (causing an error, hilariously enough).
Here's an example from the Name Manager that shows the issue I'm still running into.
Original: (works for single sheet)
What I put in: (Cell AE28 returns the name of the sheet)
What Excel gives me back:
What should I be trying to get Sheet2 to disappear from the statement, and still have my graphs functional?
The INDIRECT command has been helpful, but whenever I try to use it, Excel automatically puts the name of the current sheet in next to it (causing an error, hilariously enough).
Here's an example from the Name Manager that shows the issue I'm still running into.
Original: (works for single sheet)
Code:
=OFFSET(Sheet2!$A$25,,,Sheet2!$A$39)
Code:
=OFFSET(INDIRECT("'" & $AE$28 & "'!$A$25"),,,INDIRECT("'" & $AE$28 & "'!$A$39"))
Code:
=OFFSET(INDIRECT("'" & [U]'Sheet2'![/U]$AE$28 & "'!$A$25"),,,INDIRECT("'" & [U]'Sheet2'![/U]$AE$28 & "'!$A$39"))What should I be trying to get Sheet2 to disappear from the statement, and still have my graphs functional?
