When printing, does one trademark occupy one page?
As shown in the picture above, insert an ActiveX control button, double-click the button, and write the following program code:
Private Sub CommandButton1_Click()
For i = 1 To 100
For j = 1 To Range("B" & i)
Range("A" & i).PrintOut
Next
Next
End Sub
Cancel the "Design Mode" and click the button to batch print in the way you want