Okay I have what maybe a simple question and then again maybe not.
I have this formula in cell Q6 of every worksheet:
"Week Three" is the tab name of the sheet before "Week Four".
How can I put this information in that cell when a new sheet is inserted. Can i add a line of code in the code below to do this? Below is my insertion code:
Dim Index As Long
Dim NewWorksheet As Worksheet
Worksheets("Template").Visible = True
Worksheets("Template (2)").Visible = True
Worksheets("Template").Visible = False
Set NewWorksheet = Worksheets("Template (2)")
On Error Resume Next
For Index = 1 To 1000
NewWorksheet.Name = "Week " & GetSpelledNumber(Index)
If Err.Number = 0 Then Exit For
So in other words with I'm insert the template and it reads "Week Five" on the tab, the in cell Q6 should read ='Week Four'!Q6+7. This will update the fields for each date needed.