Needing formula to copy over without referencing master workbook

[dwalls]

First time posting on the forum. I don't consider myself an expert in Excel. I have built a macro to copy a 'template' employee attendance calendar to 300+ workbook folders within my employee files (each workbook is an individual's attendance record with each sheet representing a year). While the macro has saved countless hours from the original method of copy & pasting a new year template to each file, there is 1 major hiccup. In the pictures below, I am wanting the Previous year's point total to carry over to the next sheet to help keep a running total. When the macro runs, I can either have the sheets reference my 'template' sheet that runs the macro or put a "#" sign before the formula (neither are what I need). Any help would be greatly appreciated in automating this! I currently am running the macro to put future years in but then having to individually open the 300+ files to change the "#" to an = sign to make it a formula.

 

[iliace]

If all you need to do is replace the # with =, couldn't you just add it to your macro?

Dim wkb As Excel.Workbook
Dim wsh As Excel.Worksheet

'''''' whatever steps to create your workbook

For Each wsh In wkb.Worksheets
  wsh.Replace What:="#", Replacement:="="
Next wsh