Title pretty much says it all. I need a macro that will find duplicates in column B, there will never be more than one duplicate for each row, and keep the value in A from the first occurrence, but replace B:H values with the values in the duplicate occurrence, then delete the duplicate occurrence. Given that I'm very much down to the wire on this one I have also posed this question in a thread in which I was trying to solve a similar problem here: http://www.mrexcel.com/forum/excel-q...ml#post3764393.
Been googling for awhile to no avail, help is appreciated!
Bookmarks