Move Row from one worksheet to another based on cell value

[danjameswalker]

Firstly; I'm aware this has been asked loads but I just can't figure it out!

I would like to move an row from my Worksheet "Action Log" to another worksheet "Closed Actions" when an "x" is input in the Complete column of my table.

From what I understand I need to use VBA code but I've tried putting a few of the code strings in with no luck.
Each row has some formulas in and some conditional formatting. The Complete column only has conditional formatting in. I don't know if that confuses it

I have never used VBA before so could someone break it down as if youre talking to an infant

 

[human688]

This worked perfectly! You are truly a life saver!! Thank you!!

 

[mumps]

You are very welcome.

 

[human688]

Hello Old Friend I was hoping to add one more small change to the above coding. I was wondering if I can add a date/time stamp. I would like it to appear in column M on the "Received Orders" sheet once the "Received By" dropdown is clicked and the line gets moved to the "Received Orders" sheet. Let me know if you need any further information or if this is even possible.

Thanks!!

 

[mumps]

Try:

Private Sub Worksheet_Change(ByVal Target As Range)
    If Intersect(Target, Range("L:L")) Is Nothing Then Exit Sub
    If MsgBox("Are you sure you want to move row " & Target.Row & " to the 'Received Orders' sheet?", vbYesNo) = vbYes Then
        Application.EnableEvents = False
        With Sheets("Received Orders")
            Target.EntireRow.Copy .Cells(.Rows.Count, "A").End(xlUp).Offset(1)
            .Cells(.Rows.Count, "M").End(xlUp).Offset(1) = Now()
        End With
        Target.EntireRow.Delete
        Application.EnableEvents = True
    End If
End Sub

 

[human688]

So this worked to a point. It time stamped Row 2 on the Received Orders sheet though and the row I moved went to Row 5. Is there a way to make the time stamp match the destination line?

 

[human688]

So this worked to a point. It time stamped Row 2 on the Received Orders sheet though and the row I moved went to Row 5. Is there a way to make the time stamp match the destination line?

Oh, wait. I see that if all of the above cells are filled (which they will be when the sheet is live, it filled the first available which does match the destination line. Sorry. No need for revisions. Thank you!!!!

 

[mumps]

You are very welcome.