Doc you are an absolute legend!!!

I used your first suggestion!

Code:
Sub Macro4()
 Let Range("P24").FormulaR1C1 = "=RC[-1]"
End Sub
Worked right off the bat. Thanks so much!