Printing one sheet with different numbers

[markman235]

Hi everyone,

I have a safety evaluation sheet that every employee completes every month. I am currently printing off copies and hand writing their employee numbers across the top.

Is there a way to get Excel to print one sheet with the different employee numbers? I found how to get it to print sequential numbers, but because employees come and go, we have some gaps that would waste paper to print.

Any thoughts?

Thanks,

Mark

 

[JLGWhiz]

If you are using VBA to print the sheet then you could list the valid employee numbers in a column on another sheet and use something like this.
Assume emp nos are in Column A, sheet 2 beginning at row 2. Also assume emp number for sheet 1 is to appear in cell A1.

Sub t()
Dim c as Range
     For Each c In Sheet2.Range("A2", Sheet2.Cells(Rows.Count, 1).End(xlUp)) 'makes range dynamic
          If c <> "" Then Sheet1.Range("A1") = c.Value
                Sheet1.PrintOut
          End If
     Next
End Sub

 

[markman235]

Thank you so much!!! You have just saved me so much time each month!!!

 

[JLGWhiz]

Thank you so much!!! You have just saved me so much time each month!!!

You're welcome,
regards, JLG