Reference Formulas in Templates

08/13/21
Accepted

Hello,

I have created two templates from sheets that reference each other in a SUM+DATE formula. I would like the new sheets created by the template to reference each other, but at this moment they reference the old sheet from which the template came and need to be changed manually. Any way to achieve this?

Thanks in advance for any insight.

Best Answer

  • Accepted Answer

    Hello,

    Yes, what you are trying to achieve can be done by simply placing your two template sheets into a single folder. Next, instead of copying the sheets individually, right click on the folder and select Save as New. At this point a Save as New options box populates. At the bottom, there will be an option to select link relationships. Default selection is "Newly created sheets", which is what you would need.


Answers

  • Accepted Answer

    Hello,

    Yes, what you are trying to achieve can be done by simply placing your two template sheets into a single folder. Next, instead of copying the sheets individually, right click on the folder and select Save as New. At this point a Save as New options box populates. At the bottom, there will be an option to select link relationships. Default selection is "Newly created sheets", which is what you would need.


  • That worked perfectly. Thank you very much.

Sign In or Register to comment.