Any one can help to find out the macro code for automatically come date at the right side when left side of cell is as "completed"?
Any one can help to find out the macro code for automatically come date at the right side when left side of cell is as "completed"?
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column <> 8 Then Exit Sub If Target.Count > 1 Then Exit Sub If Target.Value = "Completed" Then Target.Next.Value = Now End Sub
I have tried the macro is not working... can do add it in the excel file and attached it. i need it in all the sheet 1.and tome should not change!!
Try to write "Completed" in column H
I need it for all the colum!in excel
Ok
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Count > 1 Then Exit Sub If Target.Value = "Completed" Then Target.Next.Value = Now End Sub
can you include and attch file?
please check attachment
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks