I currently have a template sheet that is saved over and used across numerous projects which has the current prices for standard bits of equipment. I would like to do a cost analysis of what has been costed and the variance on that cost.
I am trying to find a way that i can do links to the cells within that page that i can update to the job specific document easily. Is there a master link option, where i can just change the document name that it is linked to (all the cells will be in the same spot).
Any help on this would be appreciated