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