Moving row to a new sheet based on cell value

[Rturk]

There are previous threads on this (copy row and a cut row) but I have been unable to get either code to work.
I have a workbook I call "Pipeline (date)" inside that workbook I have a spreadsheet called "Opportunities" and in column J of this spreadsheet I have created a drop down menu the selection I want to trigger a move is "6. Awarded"
I would love to make it so once I selected "6. Awarded" and ran the macro it would move that opportunity to another spreadsheet which I have titled "Awards"
I would like the move to be a cut and paste.
Any help would be appreciated.

 

[mumps]

Copy and paste this macro into the worksheet code module. Do the following: right click the tab name for your "Opportunities" sheet and click 'View Code'. Paste the macro into the empty code window that opens up. Close the code window to return to your sheet. Make a selection in column J.

Private Sub Worksheet_Change(ByVal Target As Range)
    If Intersect(Target, Range("J:J")) Is Nothing Then Exit Sub
    Application.EnableEvents = False
    If Target = "6. Awarded" Then
        Target.EntireRow.Copy Sheets("Awards").Cells(Sheets("Awards").Rows.Count, "A").End(xlUp).Offset(1)
        Target.EntireRow.Delete
    End If
    Application.EnableEvents = True
End Sub

 

[Rturk]

Thank you!!! Worked like a charm!!!!

I do have a follow up. Now that I have this code if there was another column and cell I want to provide conditions on, can I just add it below this code? Or do I need to save them as separate macros?

 

[mumps]

You are very welcome.

Now that I have this code if there was another column and cell I want to provide conditions on, can I just add it below this code? Or do I need to save them as separate macros?

Please describe in detail exactly what you want to do referring to specific cells, rows, columns and sheets.