I am a intermediate user of Excel. I don't know if this is possible but this
is what I would like to do. I am going to a trade show that particpants will
come to our booth and be able to register for a prize. They will only be
able to enter once. But over the course of the 3 day show, people come back
2 or even 3 times. So is it possible to have a form/box that would I can:

1. enter a unique identifer # into and then a search would look for a
duplicate.
2. if duplicate is found, would show the duplicate information.
3. if no duplicate is found, the cursor would go to the next empty record
and be ready for the input of the new information.

If you need more information in order to help me, please email me at


Thank you!!