Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
printing | About this forum | |||
Excel 2003 printing problem--printing 1 document on 2 pages | Excel Discussion (Misc queries) | |||
Excel Printing --Borders are not printing on the same page as data | Excel Discussion (Misc queries) | |||
Printing a heading on each new page when printing | Excel Discussion (Misc queries) | |||
Enable Double sided printing contiuously when printing multiple s. | Excel Discussion (Misc queries) |