Need to modify a Macro

**belboy87** · 04-11-2009, 11:57 AM

Here is the Macro:

Please Login or Register  to view this content.

This is the data that it modifies:

FamilyName..Address1...FirstName...LastName...Relationship...... Phone #
10000001.....1234 Rd....John..........Doe...........Father..............1234
10000002....................John..........Doe..........Other.......... ......5678
10000002...5678 ln.......John..........Doe...........None .......................
10000003...2468..........Jane...........Doe...........Grandmother..... ..1234

And this is the output after the Macro is run:

FamilyName Address1...FirstName....LastName....Relationship........Phone #
10000001...1234 Rd.....John.............Doe .........Father...............1234
10000002...5678 ln......John.............Doe .........Other None........5678
10000003...2468.........Jane.............Doe .........Grandmother......1234

What the Macro does is it verifies that a row is a duplication by comparing: FamilyName , FirstName and LastName. Once it's verified the duplication, it combines data when there is a blank... for example, Row 2 (after being run through the Macro) now contains Address1 information AND Phone #. It also aggregates the Relationship column (notice Other and None being combined).

What I NEED it to do, is I need the aggregation to not happen if the Relationship data is the same (ie; if Rows 2 and 3 have "Mother", the macro makes the final row "Mother Mother" and I need it to just make it "Mother")

I also need the Address and Phone data that combines, to not only copy over blank cells, but also cells that say "Same".