How to add rows based on specific columns.

[decojones]

Hello all,

I have a question that I'm not quite sure how to ask. I have an excel document that certain rows dont add up with what is on a few separate columns. For example:

Let us say Column1 and Column3 are last names.

| Column1|Column2|Column3|Column4|
|__alpha_|________|__alpha_ | _______ |
|__bravo_| _______ |__alpha2| _______ |
|__charlie| _______ |__bravo | _______ |
|__Delta_| _______ |__bravo2| _______ |
|__Ekco_| _______ |__charlie| _______ |
|__fox___| _______ |__Delta__| _______ |

Instead of moving column1 down to match what is on column3 I would like to write an If statement(maybe) that can look if column3 does not = column1 then move the row down 1 until it is aligned with column3 so it can look like this.

Column1|Column2|Column3|Column4|
|__alpha__| _______ |__alpha__| _______ |
| _______ | _______ |__alpha2_| _______ |
|__bravo__| _______ |__bravo__| _______ |
| _______ | _______ |__bravo2_| _______ |
|_charlie__| _______ |__charlie_| _______ |
|__Delta__| _______ |___Delta_| _______ |

I hope you guys can understand what I'm trying to say and are willing to to take on the challange if not please ask so I can try to explain better.
Please excuse the underscores I was unable to put spaces without them -Edit

[MarMo]

hi ,
Attached a small example file that should do the trick.
Perhaps anyone could modify or simplify it .
Hope it helps.

[JBeaucaire]

In case the button gets clicked a second time, add this:

Please Login or Register  to view this content.

[MarMo]

JBeaucaire ,
As i'm always learning something new , could you explain why the change in the code.
Thanks
MarMo

[JBeaucaire]

Try clicking your macro button twice, watch what happens to the data the second time. The change I suggested basically causes "already split" cells (blank in column A) to be skipped the next time around.