{"id":12817,"date":"2021-12-10T06:21:15","date_gmt":"2021-12-10T06:21:15","guid":{"rendered":"https:\/\/lgildv5i97.onrocket.site\/answers\/?post_type=question&#038;p=12817"},"modified":"2021-12-10T06:21:34","modified_gmt":"2021-12-10T06:21:34","slug":"solved-i-need-a-macro-to-copy-data-to-an-archive-sheet","status":"publish","type":"question","link":"https:\/\/computing.net\/answers\/office\/i-need-a-macro-to-copy-data-to-an-archive-sheet\/17642.html","title":{"rendered":"Solved I Need a Macro To Copy Data To An Archive Sheet"},"content":{"rendered":"<p>I need a macro that copies data from various cells in calculator then paste them in an archive sheet. the cells are not in any particular order but they will be in the archive sheet. then i need the macro to move down 1 row to the next blank row and zero out the calculations on the calulator sheet. and repeat every time this button is pressed.<\/p>\n<p>CAN ANYONE HELP!!!!????<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"inline_featured_image":false,"iawp_total_views":4},"question-category":[53],"question_tags":[],"class_list":["post-12817","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\/12817","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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/comments?post=12817"}],"wp:attachment":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/media?parent=12817"}],"wp:term":[{"taxonomy":"question-category","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question-category?post=12817"},{"taxonomy":"question_tags","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question_tags?post=12817"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}