Reference Formulas in Templates

estradamee

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.

Tim Shaded

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.

Tim Shaded

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.

estradamee

That worked perfectly. Thank you very much.