User Profile
Justin_Grunigen
Copper Contributor
Joined 5 years ago
User Widgets
Recent Discussions
Reference Data File Paths Change When I Paste Template in New Location
Good Morning, I have searched and am not finding a solution to my problem. Please point me in the right direction if there is a thread for this all ready I'm overlooking. I have a template that is designed to pull from a table of data. The table is a separate file that gets updated constantly. The location and name of the table does not change for each project. I am trying to get my template to pull from this table with an index & match formula. It works great, however when I copy and paste the template into a new location the file path to the table changes. WHY? I want to reference the same table, same name, same location - regardless of where I copy and paste the template file. Why is that so difficult... I do not want users to have to have both files open to update it either so INDIRECT will not work. I prefer not to overcomplicate it with VBA either but I'm running out of options. Thank you for any help you can provide.Solved3.1KViews0likes2Comments
Recent Blog Articles
No content to show