Copy Selected cells to another sheet

I really need it to get a combined code to two sets of values, all have the same columns to copy from but when copying to deposit the values of "RLCMO", Or "RPCMO" Or "RLCMOEC" Or "RPCMOEC" to place the value of columns “U”, “X”, and “AA” into Deposit Column “E”. Copy columns “U”, “X”, and “AA” into Deposit Column “D” for column “K” values of "RLDMO", "RLNDMO", "RLDMOEC", "RLNDMOEC", "RPDMO”, RPNDMO”, ‘RPDMOEC", "RPNDMOEC”. I am not sure how to do it so I was trying to get the first part to run in a code then I could change the appropriate columns to run the other set of values. Data in columns “I” on Sign to “A” on Deposit, “COMPLETED – TRACS” on Deposit “B”, “J” on Sign to Deposit “C”, “S” on Sign to Deposit “” F” and “T” on Sign to Deposit “G” on the first run. The second time through if there is data in column “Y” the copy cells are the same for the first three copying and only the Sign cells change to Cells “V” and “W” for Deposit columns “V” and “W” to Deposit columns “F” and “G” and on third run Sign columns are “Y” and “Z” to Deposit columns “F” and “G”. Sign columns “U”, “X” and “AA” to Deposit column “E”.

I have tried to get a for next loop to work by itself but can’t get it to work. I also tired this code but the statement of checking the last row on Sign
And stopping it if it is equal to or larger that the last row in use on sign. I have stepped through it and on the first time it hits but it just shows that Kcol is 5 and LastRow is 22 then exits the sub and starts over at the first row again.

This is what I tried without success. I can’t figure out why I can’t get this code working.

Please Login or Register  to view this content.

All Help is greatly appreciated.

xladept

Thanks that makes it loop through now but it doesn't copy all the row data. when I step it through some times it will pickup the first check info for 75. but won't pickup the second one in the same row and won't pick up a single entry for 150.00 then the next time it will. I see no reason for it to jump over it.
I have Added Enable.Events = false thinking that was the problem but it changed nothing.
Do you see any reason for the arbitrary coping in my code?

Thank you very much! I was just coming back to up date my problem.
I had just found my problem. Both yours and mine work so I am going to post my version as well.

Please Login or Register  to view this content.

Thanks again for all your help and patience!
Have a great day!