{"id":7172,"date":"2021-11-23T10:09:46","date_gmt":"2021-11-23T10:09:46","guid":{"rendered":"https:\/\/lgildv5i97.onrocket.site\/answers\/?post_type=question&#038;p=7172"},"modified":"2021-11-23T10:13:19","modified_gmt":"2021-11-23T10:13:19","slug":"excelprint-specific-pg-based-on-cell-content","status":"publish","type":"question","link":"https:\/\/computing.net\/answers\/office\/excelprint-specific-pg-based-on-cell-content\/11948.html","title":{"rendered":"Excel:Print Specific Pg Based On Cell Content"},"content":{"rendered":"<p>Hello,<\/p>\n<p>I have a workbook in excel with a number of different worksheets. I would like a way to set it so that when a user prints the workbook it only prints specific pages based on whether a specific cell in each worksheet has content or not.<\/p>\n<p>Here are the names of each of the worksheets along with the cell that is of importance:<\/p>\n<p>Main &#8211; I never want this to print<br \/>\nNew AX43<br \/>\nCont_Sheet B3<br \/>\nOrange AX43<br \/>\nO2 AX43<br \/>\nVodafone AX43<br \/>\nT-Mobile AX43<br \/>\nThree AX43<\/p>\n<p>So, for example, if the cell AX43 on the worksheet named &#8220;Orange&#8221; has something in it, then when the user presses print, I want worksheet &#8220;Orange&#8221; to print. Same for all the other worksheets where the specified cell above is full. Any worksheets where the specific cell is empty, then I want that worksheet omitted when printing the workbook.<\/p>\n<p>Is this possible?<\/p>\n<p>Many thanks in advance<\/p>\n<p>Amy.<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"inline_featured_image":false,"iawp_total_views":0},"question-category":[53],"question_tags":[],"class_list":["post-7172","question","type-question","status-publish","hentry","question-category-office"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question\/7172","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question"}],"about":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/types\/question"}],"author":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/comments?post=7172"}],"wp:attachment":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/media?parent=7172"}],"wp:term":[{"taxonomy":"question-category","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question-category?post=7172"},{"taxonomy":"question_tags","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question_tags?post=7172"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}