You can also look at Chip Pearson's page on dealing with duplicates and
uniques for some other ideas:

http://www.cpearson.com/excel/duplicat.htm

--
Regards,
Tom Ogilvy

"pauluk " wrote in message
...
Does anyone know how to creat a macro that runs in the background and
preforms the following:

If a enter information into a spreadsheet, then keep updating this
spreadsheet with information there is away if i enter information into
a row and it is exactley the same as a perious row a error box pops up
adn says this is a dupication?

Regards
Paul


---
Message posted from http://www.ExcelForum.com/