Excel to print individual pages by rows

Ldelgado3914 

If you use the desktop version of Excel for Windows or Mac, you can use a macro to do this.

It could look like this - you'll have to modify it for your workbook.

Sub PrintBadges()
    Dim wsh1 As Worksheet
    Dim wsh2 As Worksheet
    Dim r As Long
    Dim m As Long
    ' The sheet with the employee data
    Set wsh1 = Worksheets("Data Sheet")
    ' The sheet with the enrollment form
    Set wsh2 = Worksheets("Form Sheet")
    ' I assumed that the badge numbers are in column A of the data sheet
    ' m is the row number of the last used row in that column
    m = wsh1.Range("A" & wsh1.Rows.Count).End(xlUp).Row
    ' Loop from row 2 to the last row
    For r = 2 To m
        ' I assumed that the badge number has to be entered in B2 of the form sheet
        ' Copy the badge number from the data sheet to the form sheet
        wsh2.Range("B2").Value = wsh1.Range("A" & r).Value
        ' Print the form sheet
        wsh2.PrintOut
    Next r
End Sub