Macro to move certain records to another file given certain criteria

I am struggling to create macros to:
1. move all records with "completed" in column D of the "pending" workbook to the first open row of the "completed" workbook
2. move the record automatically when column D reads "completed"

I was told the macros below works, but it doesn't work for me- on a macro enabled file and setting... any assistance would be appreciated :-)

I am trying to create a macro that will automatically move a record from the "pending" worksheet to the first open row of the "completed" worksheet as soon as "completed" is entered into column D of the "pending" worksheet. I have a macro on the "pending" worksheet to initiate the other macro when "completed" is entered into column D of the "pending" worksheet, but whenever I enter ANY data into ANY cell, i get "compile error - Block if without End if"

Any assistance is appreciated :-)

thanks - currently I have one macro on the worksheet to trigger the move, then I have a second macro to actually execute the move - which of these macros does yours replace?

thanks so much! it works perfectly!

Can anyone help me to create a macro based on the below requirements?

On daily basis I will receive an production file from the production team, the production numbers may change based on the inventory.

Total employees: 10 and they produce 500 records means I need to pick rows randomly based on the % which.

For example, if I am receiving the production file which contain 500 rows means I need to allocate certain 50% for above $10k amount or 40% for 7kto 9999k 30% for 5k to 6999k 10% for below 5k for doing an random audit. (% also vary based on the number of auditors). That random pick should cover all the employees present on that.