My company uses excel to write up service reports for our customers on a call by call basis. Each ticket has a specific number that is generated. When the ticket is completed, I have the program open up a log sheet and add the customers information to a list for easy referencing.
It has been requested that I make a button or a command of some kind they can click on and export certain cells in that row to a time sheet so they do not have to fill it out manually every week. I am confident I can to the exporting portion of it but is there a way to add some kind of command to each line they can click on to make this happen? It would have to be specific to the row it is in and be added to every line.
I do not let my techs access the original log sheet but I have a second sheet that when opened it imports the sheet to there workbook. I have attached examples of the forms I am using.
Thank you.
Max
Bookmarks