The following code should do the task for you:-
Private Sub Worksheet_Change(ByVal Target As Range)
Application.ScreenUpdating = False
If Target.Count > 1 Then Exit Sub
If Target.Value = vbNullString Then Exit Sub
If Intersect(Target, Columns("F:F")) Is Nothing Then Exit Sub
If Target.Value = "Paid" Then
Target.EntireRow.Copy Sheet2.Range("A" & Rows.Count).End(3)(2)
Application.CutCopyMode = False
Application.ScreenUpdating = True
When the word "Paid" is typed into any cell in Column F (Status Column) and you click away or press enter or down arrow, the relevant row of data is transferred to sheet2 (Paid).
To implement the code, right click on the "Unpaid" sheet tab and from the menu that appears, select 'view code". In the big white field that then appears, paste the above code.
Go back to the "Unpaid" sheet and type "Paid" in any cell in Column F then click away (or press enter or down arrow) and you will see that the data has been transferred to sheet2 ("Paid").
If you wish to delete the "used" data from the "Unpaid" sheet once a row of data has been transferred, then in the above code you will see that line 11 is in green font with an apostrophe in front of it. Remove the apostrophe and the delete line of code will be activated.
Following is the link to my test work book for you to play with:-
Type "Paid" into any cell in Column F to see it work.
I hope that this helps.