Hi,
The below code i have had helped with in a previous thread. However, i am trying to enter a formula in the last row of data in Col C but it isnt entering it.
Additionally when this data has been enter i would like it to be copied and pasted values and the subsequent column D - 0 the values to be cleared.
Many thanks
The below code i have had helped with in a previous thread. However, i am trying to enter a formula in the last row of data in Col C but it isnt entering it.
Additionally when this data has been enter i would like it to be copied and pasted values and the subsequent column D - 0 the values to be cleared.
Many thanks
VBA Code:
Sub Macro4()
'
With Range("C" & Rows.Count).End(xlUp)
.Offset(, -2).Resize(, 14).Copy
.Offset(, -2).Insert xlDown
End With
With Range("C" & Rows.Count).End(xlUp).Select
FormulaR1C1 = "=IF(R[-1]C=""Mar"",""Jun"",IF(R[-1]C=""Jun"",""Sep"",IF(R[-1]C=""Sep"",""Dec"",IF(R[-1]C=""Dec"",""Mar""))))"
End With
End Sub