Match two columns with macro and shift cells down

Good Afternoon,
I have to match up accounts and payments that my company receives with the information from our client which can be different.

There may be different payments for the same account or none on one side but some on the other.

I yanked this code from another site and tried to modify it. The If greater portion is the part I tried to change. The second part still works. I'd like to change the code to shift a range of cells down so that they match up with the appropriate account instead of color the accoutns colors. Please let me know if you need clarification or can provide any help.

Thanks in advance!

Updated code: Macro now shifts the last mismatch down, but not all. Anyway to make this shift on each side until all accounts match up?
The way I see it. There would be an if one side is greater than the other then shift these cells down, but if the other side is greater shift the others down and do a loop. I can't figure it out though :/

Please Login or Register  to view this content.

I think it would be hard to help without seeing the data the code is supposed to operate on, and what it's supposed to do.