Timothy King
New Member
Good Afternoon everyone,
SO I have been learning a lot of VBA in the last 6 months. But now I am stuck. Basically what I have here is a Maintenance work order generator.
On sheet one the Supervisor records the information and when he clicks on Submit work order the cells gets copied into work sheet 3 then clears the info on sheet 1 and sends out an email to the maintenance dept making them aware of the situation and a message box shows up saying that they have received their work order.
On sheet 3 I want to make a button that when clicked it will take the needed information and print off a ticket for the maintenance personal to go and fix the machine. Then in the next column the word "printed" gets displayed to know that line has been printed off already. What I want to happen is that it will search down through all of column M and print off any tickets that are not printed off yet. I could do it all with one button per line but that is a lot of coding and I am hoping that I can do it with just one button.
Any suggestions??
SO I have been learning a lot of VBA in the last 6 months. But now I am stuck. Basically what I have here is a Maintenance work order generator.
On sheet one the Supervisor records the information and when he clicks on Submit work order the cells gets copied into work sheet 3 then clears the info on sheet 1 and sends out an email to the maintenance dept making them aware of the situation and a message box shows up saying that they have received their work order.
On sheet 3 I want to make a button that when clicked it will take the needed information and print off a ticket for the maintenance personal to go and fix the machine. Then in the next column the word "printed" gets displayed to know that line has been printed off already. What I want to happen is that it will search down through all of column M and print off any tickets that are not printed off yet. I could do it all with one button per line but that is a lot of coding and I am hoping that I can do it with just one button.
Any suggestions??