Ticketing system/Query log

[mrorange1]

Hi All,

I was hoping someone could give me some feedback on the following:

I'd like to create a ticketing system/query log of sorts x 4, to track queries that I am getting. At the moment I am having to copy and paste all the details from an email in Outlook into an Excel file, to log the queries.

This is time consuming and not very user friendly at the moment.

I'd like the following functions:

Clicking a button so today's date appears
Drop down menus (I have that nailed already)
Clicking a button/or when text is entered in the next cell, will automatically generate a number acting as the ticket number and this will descend based on the row from the first column.
Possibility of when I select Status as "Closed", the Excel row automatically moves to another worksheet known as Closed Queries if possible?
Is it possible to have a row which states the time of how long a query has been opened for based on when it was added the Excel?
An alert to say of duplicate codes, without using conditional formatting?
I'd then like to link 4 different workbooks together so any codes that appear in another Excel file, it will say it was mentioned in another one?

It would also be great, if any macros could be used to fill in parts of the log automatically if i highlight certain emails. I know that part is possible

Any help would be greatly appreciated.

[rcm]

Could you be so kind to send us an excel sample of what you want accomplished?

[mrorange1]

Attachment 538242

I hope this helps?

I'd like to extract certain info from emails too to fill up other columns also.

[rcm]

OK give this a try just click on the query date column