row matching macro.

Hello,
i am looking for some help in writing a macro that will match duplicating cells in an excel spreadsheet. Here is an example.

BEFORE MACRO

id1 | example 1 | example 2 |
id2 | example 3 | example 4 |
id1 | example 5 | example 6 |
id2 | example 7 | |

AFTER MACRO

id1 | example 1 | example 2 | example 5 | example 6 |
id2 | example 3 | example 4 | example 7 | |



Thanks for your help!!!

Go ahead and put that in an actual sample spreadsheet so we can see how you're laying that data out in cells, show a before and after sheet example.

Actually, I already had this on file, see if it works for you:

Please Login or Register  to view this content.