Morning All

Please forgive this newbie question ... hopefully the answer will be a
whole heap simplier than my explanation.

I have a spreadsheet in which I enter data from fellow employees.
Each employee has a unique number, and the data from them is entered
(pasted) into a new row - with the employee numbers all in column B.

Some people will send me their data twice (or more!) and it's usually
different. Is there a simple formula I can have which warns me if an
employee number is duplicated (ie - already entered above) - so I can
promptly go back to the employee and ask them which data is correct.

Each week I create a new sheet for the next lot of data so it would
need to be a function that I can move / copy from sheet to sheet.

Thank you for reading this ... I do appreciate it.

Kind Regards to All.


--
Uncle Guinness
------------------------------------------------------------------------
Uncle Guinness's Profile: http://www.excelforum.com/member.php...o&userid=37355
View this thread: http://www.excelforum.com/showthread...hreadid=570538