{"id":3308,"date":"2021-11-03T12:19:35","date_gmt":"2021-11-03T12:19:35","guid":{"rendered":"https:\/\/lgildv5i97.onrocket.site\/answers\/?post_type=question&#038;p=3308"},"modified":"2021-11-03T12:20:07","modified_gmt":"2021-11-03T12:20:07","slug":"replace-a-worksheet-with-one-from-another-workbook","status":"publish","type":"question","link":"https:\/\/computing.net\/answers\/office\/replace-a-worksheet-with-one-from-another-workbook\/17632.html","title":{"rendered":"Replace A Worksheet With One From Another Workbook"},"content":{"rendered":"<p>I have a wb with 11 worksheets and each ws has multiple formulas. The first worksheet is called &#8216;Raw Data&#8217; which the users put their data in and the other sheets are calculating things like errors, closures, etc.<\/p>\n<p>Because of all the formulas, we want to keep the users out of the workbook and have given them their own with just a &#8216;Raw Data&#8217; page. There is one formula on this ws which calculates how long it&#8217;s taken to work each case. (It&#8217;s column Q and the formula is =IF(C3=&#8221;&#8221;,&#8221;&#8221;,IF(D3=&#8221;&#8221;,TODAY()-C3,D3-C3)) )<\/p>\n<p>Everyday for a month, the user Raw Data worksheet needs to override the ws in the main workbook so we can get the numbers off the other ws.<\/p>\n<p>Does anyone have any ideas?<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"inline_featured_image":false,"iawp_total_views":7},"question-category":[53],"question_tags":[],"class_list":["post-3308","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\/3308","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=3308"}],"wp:attachment":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/media?parent=3308"}],"wp:term":[{"taxonomy":"question-category","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question-category?post=3308"},{"taxonomy":"question_tags","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question_tags?post=3308"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}