Random Unique Number

[Mitch_s_s]

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

[Ecniv]

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.

[Mitch_s_s]

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