I have a formula That looks for a "Date:" Value in column A# and Pastes a Formula in the adjacent B cell. But i cant figure out how to make the formula dynamic
So if i have a value in A6 and in A8 - i would want the inserted formula to have the same row number T6 and T8. Right now it uses the same row number every time.
Sub Check()
Dim g As Range
Dim i As Long
Set g = Range("A8:A48")
For Each cell In g
'test if cell is empty
If cell.Value = "Date:" Then
'write to adjacent cell
cell.Offset(0, 1).Formula = "=TEXT(T8,""mmm-dd-yyyy"")&"" | ""&V8&"" - ""&U8&"" | Dept: ""&W8"
End If
Next
End Sub
