I have a report that can export duplicate data with most column values being exactly the same excluding four columns (L,M,N and U). I need a macro that will find the duplicates, remove columns L,M,N, and U to the one of the rows that has the duplicated information and add the data to empty columns (V,W,X,Y). After doing that, I need for the other duplicated row that doesn't have to new columns to be deleted.
Sorry, I don't even know where to begin!!