{"id":319,"date":"2021-09-03T19:59:26","date_gmt":"2021-09-03T19:59:26","guid":{"rendered":"https:\/\/lgildv5i97.onrocket.site\/answers\/office-copy-data-from-one-sheet-to-another-using-vba-11317-html"},"modified":"2021-09-03T19:59:26","modified_gmt":"2021-09-03T19:59:26","slug":"office-copy-data-from-one-sheet-to-another-using-vba-11317-html","status":"publish","type":"question","link":"https:\/\/computing.net\/answers\/office\/copy-data-from-one-sheet-to-another-using-vba\/11317.html","title":{"rendered":"Copy data from one sheet to another using VBA"},"content":{"rendered":"<td>\n<pre><\/pre>\n<p>I have a report that I would like to be able to separate based on the Value of Column L. For example if Row 2 Column L = &#8220;P100278&#8221; then copy and paste the entire row into Sheet &#8220;Alpha&#8221;. The report is in Sheet &#8220;Source&#8221;<\/p>\n<p>An example of some of the Values and relative Sheets are as below, noting some of the values relate to the same sheet:<\/p>\n<p>Value:                        Sheet Name:<br \/>P100278                    CPL Distance<br \/>P010129                    CPL<br \/>P100279                    SGT Distance<br \/>P010130                    SGT<br \/>P100663                    DENT SPVR<br \/>P103925                    STM<br \/>P103274                    STM<br \/>P103278                    STM<\/p>\n<p>I have browsed many other peoples questions and have tried to apply their answers to my problem however I keep getting stuck.<\/p>\n<p>As I have many other values and sheets, a brief outline of how to add to the macro would be fantastic.<\/p>\n<p>Any help would be much appreciated.<\/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":97},"question-category":[],"question_tags":[],"class_list":["post-319","question","type-question","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question\/319","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=319"}],"wp:attachment":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/media?parent=319"}],"wp:term":[{"taxonomy":"question-category","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question-category?post=319"},{"taxonomy":"question_tags","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question_tags?post=319"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}