Automatic generation of Trouble Tickets
 

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

Automatic generation of Trouble Tickets
 

Cannot really answer this one as you do not say what else happens. Wher
is the ticket number stored ?

Simply, you could store the total in cell C1 and have macro code lik
this to make the ticket number and increase the sequence number:-

TicketNumber=Activesheet.Range("A1").Valu
&Activesheet.Range("C1").Value
Activesheet.range("C1").Value =Activesheet.range("C1").Value +

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