Macro Help: Copy entire row data to new tab then delete original row data on first tab

[arooney88]

Hey everyone

I'm trying to design a workbook that will copy an entire rows data to a seperate tab once a dropdown selection (in that same row I'm trying to move) is switched to 'Completed'

Is there a way that a Macro can be triggered once that "Completed" dropdown is selected which could copy/paste that row to a new tab and then delete the original copied line?

 

[hateme28]

try this out:

A1 is the target range, just change that to whatever you need it to be.

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
    If Range("a1").Value = "Completed" Then
        Sheets("Sheet2").Range("a1").EntireRow.Value = Sheets("Sheet1").Range("a1").EntireRow.Value
        Sheets("Sheet1").Range("a1").EntireRow.ClearContents
    End If
End Sub

 

[arooney88]

I'm getting a run-time error '13'

type mismatch

this is what happens when I try to enter anything on the sheet.

 

[arooney88]

Would my target range be a specific cell? Or a column?

The dropdown for 'completed' will always be in column D so I input the above code with a target of Range("D:D")

 

[hateme28]

it needs to be a specific range, are you trying to do this for multiple rows? otherwise just use "D1"

 

[arooney88]

It would be checking one column, for multiple rows down.

 

[hateme28]

please provide an example of how the sheet looks.