Cell A1 allows user to select month from drop-down list.
Cell A2 allows user to enter his name. As soon as he enters his name
the trouble ticket no should be Jan001(if he is the first user o
January). The next user who enters his name with January selected
should be given Jan002, this should go on for 500 users.ie the troubl
ticket generated should be Jan500.

The same applies for the rest of the months.
It is irrelevant how many times, a same user enters his name, becaus
the problem related to each of his entry could be different.

How can we do this

--
Message posted from http://www.ExcelForum.com