Printing a group that is not grouped

J

jerminski73

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?
 
B

Bernie Deitrick

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
 
J

jerminski73

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"
 
Top