Code for moving rows of data automatically from one worksheet to another not working

[Kashyap_17]

I'm using the following code for moving row from sheet named Backlog to sheet named Billing, when the column J value becomes BILLED for a row. But it does not work if the range is converted to table (the row moves beyond the table rather than becoming a part of it):

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 10 Then
If UCase(Target.Value) = "BILLED" Then
Target.EntireRow.Copy Destination:=Sheets("Billing"). _
Range("A" & Rows.Count).End(xlUp).Offset(1)
Target.EntireRow.Delete
End If
End If
End Sub

Help will be much appreciated