Loop though rows and move data

Hi everyone, hope someone can help.

I would like to be able to compare the number in column A and if they are the same, move the row underneath the first in the set over to the right.

I have attached an excel sheet showing dummy data of how I would like it to look.

Thanks in advance.

Also if someone could point to towards some good learning material for advanced VBA I would appreciate that too.

See if this works for you:

Please Login or Register  to view this content.