If v = "Not Started" Then Target.Offset(0, 6) = Now() If v = "Pending" Then Target.Offset(0, 7) = Now() If v = "Done" Then Target.Offset(0, 8) = Now() ...