Hmm.. i've just tested it with three columns and it only matches up the 'AGE' column, the 'AREA' column does not come into play. The code just seems to merge the 'AREA' column if the 'AGE' column matches up. I need it only two merge the rows if 'AGE' & 'AREA' match up. I believe i need to create another if statement and another 'columnToMatch' but i'm not sure how.
Edit: to hopefully simplify what i mean: IF two or more cells in column 'AGE' match themselves, and if two or more cells in the 'AREA' column match themselves then merge rows.
Bookmarks