Jun 18 2021 05:02 AM
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.
Jun 18 2021 08:02 AM
SolutionJun 18 2021 08:22 AM
Jun 18 2021 08:02 AM
Solution