View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
bahri bahri is offline
external usenet poster
 
Posts: 8
Default 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