Excel as a 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?

Any help would be greatly appreciated.

 

[RedBeard]

Please don't use Excel for this.

Have a look at:

http://osticket.com/
https://www.zendesk.com/support/features/free-it-ticketing-system/
https://www.spiceworks.com/free-help-desk-software/

 

[mrorange1]

Unfortunately, I cannot use third party software and was hoping to use Excel functions in the mean time.

 

[RedBeard]

Well, try Access in that case, as it at least has nominal database functions.