Delete row if double
Hi all!
I have a sheet with 10 columns, and data is pasted (added) to it daily.
Sometimes there are duplicates, which I want to delete.
I am trying to write a macro that checks if A1 and B1 of the pasted row
already exist (after pasting), and if so delete the whole row.
Another macro I need is a pasting macro for these rows that pastes at the
bottom first empty row that exists.
Thanks for all the info here
bahri
|