Automated jobcard creation

Dear friends and associates,

I am trying to help automate a very manual process into a more automated process.

Background: Small company that issues approx 30 jobcards a day which each job being manually typed and then saved as a PDF. Engineers then print and populate by hand when on site.

Wish to achieve: We would like to just populate sheet 1 with the details which will automatically populate sheet 2.
I have added a button on each row and would like that when the button is pressed, sheet 2 is automatically saved as a PDF to a folder on the desktop and then sheet 2 is cleared and ready for another job to be printed.

Sheet 1 will be the master list of all repairs and will probably be saved on a month by month basis.

I have uploaded the excel file and row 6 on sheet 1 identifies the cells on sheet 2 that need to be populated.

I know a little bit on excel but this is way above my expertise.

Would be extremely grateful if someone could help or point me in the write direction.

Hi John,

I just tried the features and I am absolutely amazed. It works exactly how i wanted it to work. This will really help me in issuing job cards.
Thank you so much for your help.

If i wanted to add extra command buttons in Sheet 1 column A to approx row 250, do I need to add them manually and then modify the VBA as below.

Private Sub CommandButton1_Click()
Call Fill_Jobcard(2) ' row 2
End Sub
Private Sub CommandButton2_Click()
Call Fill_Jobcard(3) ' row 3
End Sub
Private Sub CommandButton3_Click()
Call Fill_Jobcard(4) ' row 4
End Sub
Private Sub CommandButton4_Click()
Call Fill_Jobcard(5) ' row 5
End Sub

Still can't believe it......

Originally Posted by JohnTopley

Yes you do but this is really not very practical (250 command buttons!) so I suggest a better option is to enter "From" and "To" rows and have a single Print button. Put these on a separate sheet - "Dashboard" is the common term (name) for this.

Let me know what you think and I will add the necessary VBA.

I think that may work but id like to state a scenario and see if you think your above method will work.

We only save as pdf when all information is received so sometimes we could be waiting a few days until to gather all the information. So lets say i have all the information for rows 2,3,4,5,11,15,33 and 44. Will the "from" and "to" method for saving still work.
If it will, then excellent, but if not, would a checkbox on each row be a reasonable method and whichever checkbox is ticked, a single button would save all rows with a checkbox selected.

Hi John,

When I select "Print" on Column A on the "Jobcard" sheet from the dropdown list, they do not appear on the "PRINT" sheet.
I have tried then pressing the "Print Job Cards" button, but the data is not transferring into the "PRINT" sheet.

Is it something i'm doing wrong?

Hi John,

I have just tried the new version and it works perfectly.

Many thanks for your help and time.

Much appreciated.