Printing a group that is not grouped
 

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?

Printing a group that is not grouped
 

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?

Printing a group that is not grouped
 

Wow, that should have actually worked well, all of the pricing pages have a
value in the same cell that changes as they are bidding different material
types, however, after I set the cell to AI8 (each page totals in AI8) I ran
the macro and got my master pricing sheet of 10 pgs and two other sheets with
no value in AI8.

I changed A1 to AI8 and < "" to < "0"