{"id":511,"date":"2021-09-03T20:01:41","date_gmt":"2021-09-03T20:01:41","guid":{"rendered":"https:\/\/lgildv5i97.onrocket.site\/answers\/office-macro-to-copy-paste-and-insert-rows-of-data-10382-html"},"modified":"2021-09-03T20:01:41","modified_gmt":"2021-09-03T20:01:41","slug":"office-macro-to-copy-paste-and-insert-rows-of-data-10382-html","status":"publish","type":"question","link":"https:\/\/computing.net\/answers\/office\/macro-to-copy-paste-and-insert-rows-of-data\/10382.html","title":{"rendered":"Macro to copy, paste and insert rows of data"},"content":{"rendered":"<p><td>Hi,<\/p>\n<p>I  need to develop a macro that will read all data in one worksheet (&#8220;Data&#8221;) and copy\/paste it into another worksheet (&#8220;Report&#8221;), inserting a new row for each row copied from the other worksheet (&#8220;Data&#8221;).<\/p>\n<p>The five columns in both sheet are the same. The data in (&#8220;Data&#8221;) starts on A2 and will be copied onto A5 in (&#8220;Report&#8221;). But the &#8220;Report&#8221; sheet is formatted for visual display\/presentation. So the insertion of a new row is important here.<\/p>\n<p>Any help would be appreciated!<\/p>\n<p>Thank you.<\/p>\n<\/td>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","template":"","meta":{"inline_featured_image":false,"iawp_total_views":118},"question-category":[],"question_tags":[],"class_list":["post-511","question","type-question","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question\/511","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=511"}],"wp:attachment":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/media?parent=511"}],"wp:term":[{"taxonomy":"question-category","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question-category?post=511"},{"taxonomy":"question_tags","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question_tags?post=511"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}