Printing a group that is not grouped

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jerminski73 - 22 May 2007 13:12 GMT

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?

Reply to this Message

Bernie Deitrick - 22 May 2007 13:57 GMT

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

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

Reply to this Message

jerminski73 - 22 May 2007 19:38 GMT

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"

Reply to this Message