I need a macro that can do the following:
1. Find rows that have a match in a specific row. In the example given the rows it should find are 1 and 3.
Example:
A B C
1 g j l
2 h k z
3 n j o
2. Take the data from a specific column (in this case let's say C) from the matching row. In this example it should be cell C3 or C1. Merge them in one cell. In this case C1 will now have the data 'l, o' in it after the merging.
3. Delete the matching row from which the merging data was taken (not the row where the data was merged). In this case it will be row 3.
4. The end result should look like this:
A B C
1 g j l, o
2 h k z
3
5. If it's easier to do, the data will merge in both cell (so both C1 and C3 have 'l, o' data in them) but in the end the matching row is still deleted.
Hope that was clear,
Thanks.
Bookmarks