I have linked a cell in a template sheet to the same cell in the various iterations of the template but unable to then convert the formula in each sheet to Column Formula.
Could this be considered as it could save a lot of time if a formula needs changed for any reason as updating the template would automatically update multiple other sheets