Hi,
Is there a way to create a macro that identifies equal values in various cells within a selected column range and then merges those cells together.
I have uploaded a picture to illustrate what I mean. The second column should be the final product with the merged cells.
I have found this thread where the macro seems to identify the duplicate entries and then color codes it.
http://www.exceltip.com/st/Identifyi...ange/1090.html
I was trying to edit it, but I don't have much experience in coding.
Thanks a lot! Any help is appreciated.
Bookmarks