I am new to macros and need some help. I have found numerous code for deleting all but the first instance of a duplicate row. However, I need something a little different. I have a table with about five columns of data. I need a macro that will search column 1 for duplicate entries and replace the first instance with the last one. Does anyone know if this is possible?