Checking for duplicate entries over multiple worksheets

Giganews Newsgroups
Subject: Checking for duplicate entries over multiple worksheets
Posted by:  madbloke (madbloke.27lloa_1147275301.5485@excelforum-nospam.com)
Date: Wed, 10 May 2006

I have an excel file with multiple workbooks (month by month) which,
amongst other things, contains reference number and name (columns C &
D).

When entering these details, I'd like it to check across all previous
entries (and previous months) for an exact match, and if it finds one,
to pop up a messagebox asking if it's ok to enter a duplicate.

I was thinking along the lines of a VLOOKUP formula, but that would get
overwritten when entering the data, so I'm stumped.

Any ideas?

--
madbloke
------------------------------------------------------------------------
madbloke's Profile:http://www.excelforum.com/member.php?action=getinfo&userid=14422
View this thread:http://www.excelforum.com/showthread.php?threadid=540711

Replies