Does anyone know how to creat a macro that runs in the background an
preforms the following:

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

Regards
Pau

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

Hi
though this will not create a popup it will highlight your cell. Try
the following:
- Select your entire column (lets say col A, starting in row 1)
- goto 'Format - Conditional Format' and enter the following formula:
=COUNTIF($A:$A,A1)1
choose a format to highlight a duplicate entry

For more information you may have a look at
http://www.cpearson.com/excel/duplic...tingDuplicates
http://www.cpearson.com/excel/NoDupEntry.htm


--
Regards
Frank Kabel
Frankfurt, Germany

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/

Possibly using data= validation. If you are checking duplication for a
set of multiple columns, this might be less practical.

the alternative would be to use the change event for the worksheet.

See Chip Pearson's page on events
http://www.cpearon.com/excel/events.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/

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/