copy a row range and paste to another sheet

[spycein]

Hi Everybody, actually i want to use vba to copy a range of data to another sheet.

For example i have two worksheets. Sheet one named Invoice List which contains a table as follows

Date Bill No. Amount Payament Status
1/8/14 1 100 pending
31/7/14 2 200 pending

so if i type "paid" in "payment status" column the the data of that row (start from column A to column C) except payment status column (column D) should copy and paste special to the sheet 2 named "Paid" and then delete that range.

Hope you guys understand my query.

Thank you in advance.

 

[My Aswer Is This]

Vog. Thanks for your help. The script:

[COLOR=#b22222]If Target.Address = "$C$4" Then
        Range("A:B").ClearContents
[/COLOR]

Works find for me but not when combined with other script. I'm not use to working with:

Application.EnableEvents = False

If you should think of a solution I would enjoy hearing back from you. Have a nice weekend.