Macro to align names in columns

[ndendrinos]

Hello to all,

Here is what I've inherited (example):
.........A...............B....................C...........D..............
....Co.2003....Total.2003.......Co.2004....Total.2004...
.....Dodge...........10.00...........Audi...............5.00...
.....Ford...............20.00..........Dodge............10.00...

I need a macro to align Dodge 2003 and total for that year with Dodge 2004 and the total for that year.

The position of the Co names and their totals could be anywhere in their respective columns (always two columns)
Thank you

 

[SteveO59L]

Why not sort range a:d, by col A, then col C ?

 

[ndendrinos]

Thank you Steve but this will not work
in A there might be dozens on company names preceding Dodge while
in column C their might be few.