Random Unique Number

Hi,

I need to generate a unique "ticket" number for a user in excel

they are completing a userform, and their responses are written to a central workbook.
the users will be placed in to a draw, so they will be given this unique ticket number.

the thing is, i must not be able to link this ticket number to the responses as they are to be confidential.

does anyone know of a way to do this, i was thinking of writing to the responses workbook
but again i could work this back to where the individual is located.

Thanks

Quote:

---

the thing is, i must not be able to link this ticket number to the responses as they are to be confidential

---

Wha...?

Confidential to whom? If confidential to all then no-one is going to read -ergo no need to store.
In Excel?
Relational - ie dump in a db?


If you have to use Excel, try this:
Userform - Data Entry -> contact detail (search for existing if more than one feedback) + entry of response
Userform - Search - contact info - for draw result
SheetOfContactDetails (Hidden ?)
SheetOfResponsesWithContactID (hidden sheet)
As to who can see - protect the sheet that is hidden or the workbook. Read up on security with Excel.

done this using a unique number generator i found on google

i then had an array of cells numbered from 1-1000
the code will loop until it finds an unused number (i change the cell interior once used)

works fine, as approx 600 people will use this

thanks anyway :)

oh an a db would be overkill for this