We are trying to do custom reports that are 2 pages: the front is custom per client (each on sheet 1-9) and the back is the same for each client (sheet 10). I want to print Sheet 1 as the front, Sheet 10 as the back for client A; Sheet 2 as the front, Sheet 10 as the back for client B; Sheet 3 as the front, Sheet 10 as the back for client C...and so on. The back needs to be included in every print and the front changes. Sheet 11-15 should not be printed in the file at all. Is there an way to set this up so everything prints with a single button click?
Print Set-Up
- Thread starter pmreeve
- Start date
Do you have page numbering to worry about, or is each 2 page report separate?
If the latter, and those really are your sheet names, a macro like this might work:
[pre]
[/pre]
If the latter, and those really are your sheet names, a macro like this might work:
[pre]
Code:
Sub PrintMultiples()
Dim i As Integer
For i = 1 To 9
'Assumes individual sheet numbering, not all in 1 big report
Sheets(Array("Sheet" & i, "Sheet10")).Print
Next i
End Sub