Printing
 

What code is necessary for a command button to print the Options half of every page in work sheet if a cells value on each page is 0? Another words the cell shown is 0 or in my sheet $250.00, so how do you print "Options Kitchen" on down to SubTotal and check each sheet and select to print only the line necessary if 0 to print (We may have 20 Sheets)

Room Name Type Species Counter Top Door Trim Finishing Tota
1 Kitchen Frame MDF Not Included W/A Moulding Not Included Not Included

Quantity Type Per FT Per FT Per SF Each Per FT Per FT
0.00 Upper Included $61.00 $38.00 $0.00 $0.00 $0.0
0.00 Base Included $69.00 $38.00 $0.00 $0.0
0.00 Tall 24D Included $151.00 $114.00 $0.00 $0.00 $0.0
0.00 Tall 12D Included $69.00 $114.00 $0.00 $0.00 $0.0
0.00 Vanity Included $69.00 $38.00 $0.00 $0.0
0.00 Counter Top $0.00 $0.0
0.00 Cabinet Sub Total $0.0


Options Kitchen

Quantity Type Cost
1.00 Appliance Garage Each $250.00 $250.0
0.00 None None $0.00 $0.0
0.00 None None $0.00 $0.0
0.00 None None $0.00 $0.0
0.00 None None $0.00 $0.0
0.00 None None $0.00 $0.0
0.00 None None $0.00 $0.0
0.00 None None $0.00 $0.0
0.00 None None $0.00 $0.0
0.00 None None $0.00 $0.0
0.00 None None $0.00 $0.0
0.00 None None $0.00 $0.0
Kitchen Options Sub Total $250.0
Kitchen Cabinet Sub Total $0.0
Kitchen Total $250.0