Trying to get the result of what dow1 equals to enter in the later line code code, so it will either be F12, G12 or H12.
Cannot quite get it to work - any ideas please?
If (Workbooks("Forecast Template.xlsx").Sheets("Revenue").Range("B6") = "Sunday") Then
dow1 = "H"
If...