{"id":4641,"date":"2022-12-29T10:35:28","date_gmt":"2022-12-29T03:35:28","guid":{"rendered":"https:\/\/mahisaajy.web.id\/blog\/?p=4641"},"modified":"2022-12-29T10:46:52","modified_gmt":"2022-12-29T03:46:52","slug":"menggabungkan-beberapa-sheet-menjadi-1-sheet-di-excel","status":"publish","type":"post","link":"https:\/\/mahisaajy.web.id\/blog\/2022\/12\/menggabungkan-beberapa-sheet-menjadi-1-sheet-di-excel\/","title":{"rendered":"Menggabungkan Beberapa Sheet Menjadi 1 Sheet di Excel"},"content":{"rendered":"\n<p>Kode macro excelnya seperti ini:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Sub Merge_Sheets()\n\nDim startRow, startCol, lastRow, lastCol As Long\nDim headers As Range\n\n'Set Master sheet for consolidation\nSet mtr = Worksheets(\"Master\")\n\nSet wb = ThisWorkbook\n'Get Headers\nSet headers = Application.InputBox(\"Select the Headers\", Type:=8)\n\n'Copy Headers into master\nheaders.Copy mtr.Range(\"A1\")\nstartRow = headers.Row + 1\nstartCol = headers.Column\n\nDebug.Print startRow, startCol\n'loop through all sheets\nFor Each ws In wb.Worksheets\n     'except the master sheet from looping\n     If ws.Name &lt;&gt; \"Master\" Then\n        ws.Activate\n        lastRow = Cells(Rows.Count, startCol).End(xlUp).Row\n        lastCol = Cells(startRow, Columns.Count).End(xlToLeft).Column\n        'get data from each worksheet and copy it into Master sheet\n        Range(Cells(startRow, startCol), Cells(lastRow, lastCol)).Copy _\n        mtr.Range(\"A\" &amp; mtr.Cells(Rows.Count, 1).End(xlUp).Row + 1)\n           End If\nNext ws\n\nWorksheets(\"Master\").Activate\n\nEnd Sub<\/code><\/pre>\n\n\n\n<p>Referensi: <a href=\"https:\/\/www.exceltip.com\/cells-ranges-rows-and-columns-in-vba\/consolidatemerge-multiple-worksheets-into-one-master-sheet-using-vba.html\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/www.exceltip.com\/cells-ranges-rows-and-columns-in-vba\/consolidatemerge-multiple-worksheets-into-one-master-sheet-using-vba.html<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Kode macro excelnya seperti ini: Referensi: https:\/\/www.exceltip.com\/cells-ranges-rows-and-columns-in-vba\/consolidatemerge-multiple-worksheets-into-one-master-sheet-using-vba.html<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"_links_to":"","_links_to_target":""},"categories":[390],"tags":[],"class_list":["post-4641","post","type-post","status-publish","format-standard","hentry","category-excel"],"blocksy_meta":{"styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[]}},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.0 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Menggabungkan Beberapa Sheet Menjadi 1 Sheet di Excel - Mahisa Ajy Kusuma<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/mahisaajy.web.id\/blog\/2022\/12\/menggabungkan-beberapa-sheet-menjadi-1-sheet-di-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Menggabungkan Beberapa Sheet Menjadi 1 Sheet di Excel - Mahisa Ajy Kusuma\" \/>\n<meta property=\"og:description\" content=\"Kode macro excelnya seperti ini: Referensi: https:\/\/www.exceltip.com\/cells-ranges-rows-and-columns-in-vba\/consolidatemerge-multiple-worksheets-into-one-master-sheet-using-vba.html\" \/>\n<meta property=\"og:url\" content=\"https:\/\/mahisaajy.web.id\/blog\/2022\/12\/menggabungkan-beberapa-sheet-menjadi-1-sheet-di-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Mahisa Ajy Kusuma\" \/>\n<meta property=\"article:publisher\" content=\"mahisaajy\" \/>\n<meta property=\"article:author\" content=\"mahisaajy\" \/>\n<meta property=\"article:published_time\" content=\"2022-12-29T03:35:28+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-12-29T03:46:52+00:00\" \/>\n<meta name=\"author\" content=\"mahisaajy\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@mahisaajy\" \/>\n<meta name=\"twitter:site\" content=\"@mahisaajy\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"mahisaajy\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/mahisaajy.web.id\/blog\/2022\/12\/menggabungkan-beberapa-sheet-menjadi-1-sheet-di-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/mahisaajy.web.id\/blog\/2022\/12\/menggabungkan-beberapa-sheet-menjadi-1-sheet-di-excel\/\"},\"author\":{\"name\":\"mahisaajy\",\"@id\":\"https:\/\/mahisaajy.web.id\/blog\/#\/schema\/person\/d9bfa055f34d78537afcc2d6079ff40c\"},\"headline\":\"Menggabungkan Beberapa Sheet Menjadi 1 Sheet di Excel\",\"datePublished\":\"2022-12-29T03:35:28+00:00\",\"dateModified\":\"2022-12-29T03:46:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/mahisaajy.web.id\/blog\/2022\/12\/menggabungkan-beberapa-sheet-menjadi-1-sheet-di-excel\/\"},\"wordCount\":20,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/mahisaajy.web.id\/blog\/#\/schema\/person\/d9bfa055f34d78537afcc2d6079ff40c\"},\"articleSection\":[\"Excel\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/mahisaajy.web.id\/blog\/2022\/12\/menggabungkan-beberapa-sheet-menjadi-1-sheet-di-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/mahisaajy.web.id\/blog\/2022\/12\/menggabungkan-beberapa-sheet-menjadi-1-sheet-di-excel\/\",\"url\":\"https:\/\/mahisaajy.web.id\/blog\/2022\/12\/menggabungkan-beberapa-sheet-menjadi-1-sheet-di-excel\/\",\"name\":\"Menggabungkan Beberapa Sheet Menjadi 1 Sheet di Excel - Mahisa Ajy Kusuma\",\"isPartOf\":{\"@id\":\"https:\/\/mahisaajy.web.id\/blog\/#website\"},\"datePublished\":\"2022-12-29T03:35:28+00:00\",\"dateModified\":\"2022-12-29T03:46:52+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/mahisaajy.web.id\/blog\/2022\/12\/menggabungkan-beberapa-sheet-menjadi-1-sheet-di-excel\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/mahisaajy.web.id\/blog\/2022\/12\/menggabungkan-beberapa-sheet-menjadi-1-sheet-di-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/mahisaajy.web.id\/blog\/2022\/12\/menggabungkan-beberapa-sheet-menjadi-1-sheet-di-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/mahisaajy.web.id\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Menggabungkan Beberapa Sheet Menjadi 1 Sheet di Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/mahisaajy.web.id\/blog\/#website\",\"url\":\"https:\/\/mahisaajy.web.id\/blog\/\",\"name\":\"Mahisa Ajy Kusuma\",\"description\":\"Kewajiban kita lebih banyak dari waktu yang tersedia.\",\"publisher\":{\"@id\":\"https:\/\/mahisaajy.web.id\/blog\/#\/schema\/person\/d9bfa055f34d78537afcc2d6079ff40c\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/mahisaajy.web.id\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/mahisaajy.web.id\/blog\/#\/schema\/person\/d9bfa055f34d78537afcc2d6079ff40c\",\"name\":\"mahisaajy\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/mahisaajy.web.id\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/84e68a607b6f3a00fdbccb0e208f3f66e31685e032a45bceac18338a091b5361?s=96&d=monsterid&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/84e68a607b6f3a00fdbccb0e208f3f66e31685e032a45bceac18338a091b5361?s=96&d=monsterid&r=g\",\"caption\":\"mahisaajy\"},\"logo\":{\"@id\":\"https:\/\/mahisaajy.web.id\/blog\/#\/schema\/person\/image\/\"},\"description\":\"Seorang pemuda yang mempunyai hobi menulis, membaca, dan bermusik. Tertarik dengan bidang ilmu komputer untuk memecahkan beberapa persoalan. Sejak tahun 2018 bekerja di BMKG di Direktorat Data dan Komputasi. Blog tentang Teknologi: Mahisadev.com\",\"sameAs\":[\"http:\/\/mahisaajy.web.id\/blog\/\",\"mahisaajy\",\"https:\/\/x.com\/mahisaajy\",\"mahisaful\"],\"url\":\"https:\/\/mahisaajy.web.id\/blog\/author\/mahisaajy\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Menggabungkan Beberapa Sheet Menjadi 1 Sheet di Excel - Mahisa Ajy Kusuma","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/mahisaajy.web.id\/blog\/2022\/12\/menggabungkan-beberapa-sheet-menjadi-1-sheet-di-excel\/","og_locale":"en_US","og_type":"article","og_title":"Menggabungkan Beberapa Sheet Menjadi 1 Sheet di Excel - Mahisa Ajy Kusuma","og_description":"Kode macro excelnya seperti ini: Referensi: https:\/\/www.exceltip.com\/cells-ranges-rows-and-columns-in-vba\/consolidatemerge-multiple-worksheets-into-one-master-sheet-using-vba.html","og_url":"https:\/\/mahisaajy.web.id\/blog\/2022\/12\/menggabungkan-beberapa-sheet-menjadi-1-sheet-di-excel\/","og_site_name":"Mahisa Ajy Kusuma","article_publisher":"mahisaajy","article_author":"mahisaajy","article_published_time":"2022-12-29T03:35:28+00:00","article_modified_time":"2022-12-29T03:46:52+00:00","author":"mahisaajy","twitter_card":"summary_large_image","twitter_creator":"@mahisaajy","twitter_site":"@mahisaajy","twitter_misc":{"Written by":"mahisaajy","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/mahisaajy.web.id\/blog\/2022\/12\/menggabungkan-beberapa-sheet-menjadi-1-sheet-di-excel\/#article","isPartOf":{"@id":"https:\/\/mahisaajy.web.id\/blog\/2022\/12\/menggabungkan-beberapa-sheet-menjadi-1-sheet-di-excel\/"},"author":{"name":"mahisaajy","@id":"https:\/\/mahisaajy.web.id\/blog\/#\/schema\/person\/d9bfa055f34d78537afcc2d6079ff40c"},"headline":"Menggabungkan Beberapa Sheet Menjadi 1 Sheet di Excel","datePublished":"2022-12-29T03:35:28+00:00","dateModified":"2022-12-29T03:46:52+00:00","mainEntityOfPage":{"@id":"https:\/\/mahisaajy.web.id\/blog\/2022\/12\/menggabungkan-beberapa-sheet-menjadi-1-sheet-di-excel\/"},"wordCount":20,"commentCount":0,"publisher":{"@id":"https:\/\/mahisaajy.web.id\/blog\/#\/schema\/person\/d9bfa055f34d78537afcc2d6079ff40c"},"articleSection":["Excel"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/mahisaajy.web.id\/blog\/2022\/12\/menggabungkan-beberapa-sheet-menjadi-1-sheet-di-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/mahisaajy.web.id\/blog\/2022\/12\/menggabungkan-beberapa-sheet-menjadi-1-sheet-di-excel\/","url":"https:\/\/mahisaajy.web.id\/blog\/2022\/12\/menggabungkan-beberapa-sheet-menjadi-1-sheet-di-excel\/","name":"Menggabungkan Beberapa Sheet Menjadi 1 Sheet di Excel - Mahisa Ajy Kusuma","isPartOf":{"@id":"https:\/\/mahisaajy.web.id\/blog\/#website"},"datePublished":"2022-12-29T03:35:28+00:00","dateModified":"2022-12-29T03:46:52+00:00","breadcrumb":{"@id":"https:\/\/mahisaajy.web.id\/blog\/2022\/12\/menggabungkan-beberapa-sheet-menjadi-1-sheet-di-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/mahisaajy.web.id\/blog\/2022\/12\/menggabungkan-beberapa-sheet-menjadi-1-sheet-di-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/mahisaajy.web.id\/blog\/2022\/12\/menggabungkan-beberapa-sheet-menjadi-1-sheet-di-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/mahisaajy.web.id\/blog\/"},{"@type":"ListItem","position":2,"name":"Menggabungkan Beberapa Sheet Menjadi 1 Sheet di Excel"}]},{"@type":"WebSite","@id":"https:\/\/mahisaajy.web.id\/blog\/#website","url":"https:\/\/mahisaajy.web.id\/blog\/","name":"Mahisa Ajy Kusuma","description":"Kewajiban kita lebih banyak dari waktu yang tersedia.","publisher":{"@id":"https:\/\/mahisaajy.web.id\/blog\/#\/schema\/person\/d9bfa055f34d78537afcc2d6079ff40c"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/mahisaajy.web.id\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/mahisaajy.web.id\/blog\/#\/schema\/person\/d9bfa055f34d78537afcc2d6079ff40c","name":"mahisaajy","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/mahisaajy.web.id\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/84e68a607b6f3a00fdbccb0e208f3f66e31685e032a45bceac18338a091b5361?s=96&d=monsterid&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/84e68a607b6f3a00fdbccb0e208f3f66e31685e032a45bceac18338a091b5361?s=96&d=monsterid&r=g","caption":"mahisaajy"},"logo":{"@id":"https:\/\/mahisaajy.web.id\/blog\/#\/schema\/person\/image\/"},"description":"Seorang pemuda yang mempunyai hobi menulis, membaca, dan bermusik. Tertarik dengan bidang ilmu komputer untuk memecahkan beberapa persoalan. Sejak tahun 2018 bekerja di BMKG di Direktorat Data dan Komputasi. Blog tentang Teknologi: Mahisadev.com","sameAs":["http:\/\/mahisaajy.web.id\/blog\/","mahisaajy","https:\/\/x.com\/mahisaajy","mahisaful"],"url":"https:\/\/mahisaajy.web.id\/blog\/author\/mahisaajy\/"}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p3PanY-1cR","jetpack_sharing_enabled":true,"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/mahisaajy.web.id\/blog\/wp-json\/wp\/v2\/posts\/4641","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mahisaajy.web.id\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mahisaajy.web.id\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mahisaajy.web.id\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mahisaajy.web.id\/blog\/wp-json\/wp\/v2\/comments?post=4641"}],"version-history":[{"count":2,"href":"https:\/\/mahisaajy.web.id\/blog\/wp-json\/wp\/v2\/posts\/4641\/revisions"}],"predecessor-version":[{"id":4646,"href":"https:\/\/mahisaajy.web.id\/blog\/wp-json\/wp\/v2\/posts\/4641\/revisions\/4646"}],"wp:attachment":[{"href":"https:\/\/mahisaajy.web.id\/blog\/wp-json\/wp\/v2\/media?parent=4641"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mahisaajy.web.id\/blog\/wp-json\/wp\/v2\/categories?post=4641"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mahisaajy.web.id\/blog\/wp-json\/wp\/v2\/tags?post=4641"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}