Ticket bug report in Excel
Objective
As a QA Tester, I wanted to create a tool for reporting bugs into a database to use it in personal projects where I don't have a license on bug reporting tools like Mantis.
How to use it
On the first sheet called "ticket" you just have to fill in the ticket. (Dropdown menus are available from "Category" to "Priority") and then confirm the ticket.
Once the button clicked, the sheet clears itself. Then you can open the "database" sheet to see that your ticket is now added to your database !
How does it work ?
The first step is to define the variables that I will use to move the content of a cell from one sheet to another.
The second step is to tell Excel that these variables correspond to the sheets that I will use.
In the tird step, I'm going to create 6 sets of 2 variables.
These variables will be used to define the database.
In the fourth step, we will use the variable "lstrw" (last row) to check if the line above is empty or not.
Then we'll use the variable "pstrw" (past row) to past the cell from the "ticket" sheet on the first empty row of the "database" sheet.
Then I just repeated the operation for the other cells !Â
The excel file.
ROSELLO_Nicolas_TicketBugReport.xlsm