copy specific cells in row based of of value in anpther cell to another worksheet.

Hello all.
I need help with this code. I am trying to get this code to loop through each line copying the row information for the deposit that is listed as "RLCMO" or “RPCMO” in cell “H” in the SIGN_IN sheet to the sort sheet. I have tried to get it to loop but can’t seem to get it to go. the code is located in sub routine CAP_PD_DEPOSIT TRANSFER() in Module1. All help is greatly appreciated!

Please Login or Register  to view this content.

Thanks again for all help on this.

"Target" is a variable for worksheet event, not for Module procedures.

If anything, it should be:
For worksheet module:

Please Login or Register  to view this content.

For "Module1" module:

Please Login or Register  to view this content.