Hi.
I want a macro that will look for duplicate rows, delete them but leave the last entry available. The thing is I have 4 columns where the information has to be duplicated for it to erase it. Here is an example:
Fecha Recolección en Danone # Shipment Localidad Tienda
09/11/2012 34566 MANTE Soriana
09/11/2012 34566 MANTE Soriana
Since the 4 columns have the same information, I want it to delete the first row and leave the second.
How can I do that?
Regards,
Bookmarks