| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Checking for duplicate entries over multiple worksheets
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...o&userid=14422 View this thread: http://www.excelforum.com/showthread...hreadid=540711 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Functions across multiple worksheets | Excel Worksheet Functions | |||
| Sumif with multiple worksheets | Excel Worksheet Functions | |||
| Printing Multiple Worksheets | Excel Discussion (Misc queries) | |||
| outputting to multiple worksheets | Excel Discussion (Misc queries) | |||
| Update multiple worksheets | Excel Discussion (Misc queries) | |||
Threaded Mode
