This template is being used to break down a file into five unique files that are frequently uploaded. While this template will be saved in multiple locations, the 'source' file will always be stored in the same folder as the template and will always have the same name.
I have two workbooks in the same folder. When I link cells between the two workbooks, I get:
='[File Name]Tab Name -1'!$P$1302
Everything works well at that point. When I close the 'source' file, all of my linked formulas change to:
='File Location\[File Name.xlsx]Tab Name -1'!$P$1302
This means that all of the template's cells are linked to the 'source' file in a very specific location. My goal is to save a 'Template_Folder' in multiple places because each template will be fed a unique 'source' file.
Am I missing an easier way? I've tried searching a plethora of key words, but am coming up empty handed on this deal.
Thanks and have a good day!
Michael
Bookmarks