I have found the following code on here and it does nearly what i want but i need to make some mods but have no idea how????
bascally this code looks at the text in Cell 11 and if it says "complete" moves the entire row to another work sheet labelled "completed".
My problem is that it seems to place the cut row on any row in the completed sheet not the next avalible line???
Additionally i would like to add a date to the rows that are moved ???

Private Sub Worksheet_Change(ByVal Target As Range)
Dim LR As Long
If Target.Count > 1 Then Exit Sub
If Target.Column = 11 And LCase(Target.Value) = "complete" Then
Application.EnableEvents = False
With Sheets("completed")
LR = .Range("A" & Rows.Count).End(xlUp).Row
Target.EntireRow.Copy Destination:=.Range("A" & LR + 1)
Target.EntireRow.Delete
Application.CutCopyMode = False
Application.EnableEvents = True
End With
End If
End Sub