You could use a macro. For example, if cell A1 has the "qty" of interest:

Sub PrintSheets()
Dim mySht As Worksheet
For Each mySht In ActiveWorkbook.Worksheets
If mySht.Range("A1").Value < "" Then mySht.PrintOut
Next mySht

End Sub

HTH,
Bernie
MS Excel MVP


"jerminski73" wrote in message
...
I have a document with 11 different sheets in it. If a qty is entered on any
of the sheets I would like it to be included in the group to be printed. Is
there a function to print sheets with changes from the "template" that I
have created?