Excel template sheet links

Copper Contributor

Hi there,


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

1 Reply



This sounds like a job for the INDIRECT function. That's a hyperlink, in that last sentence, to a website that explains INDIRECT.


If that does NOT fit your need, please come back with a more complete description and, ideally, a sample copy or two of the spreadsheet template and one or two of the specific job files built on it. You can post those samples on OneDrive or GoogleDrive with a link pasted here that grants access to the files.