Go to this page, there are several examples to do what you wish. One way
would be with data validation to display and error dialog when a duplicate
entry is made this is explained on this page.
http://www.cpearson.com/excel/topic.htm
HTH
"****al" wrote in message
...
I have data with Date, Invovice No.,Party Name, Item Name,
Qty.,Rate,Amt.

Some times i enter the same invoice no. two times and i am
not able to make a track of it.
is there any way with macro when i click on macro button
it will ask me do u want to delete dublicate invoice no.
and than it will delete enter-row.

is any help.

****al Shah