{"id":2016,"date":"2024-12-02T06:46:45","date_gmt":"2024-12-02T06:46:45","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/macro-gop-du-lieu-nhieu-sheets-excel-vao-1-sheet\/"},"modified":"2024-12-02T06:46:45","modified_gmt":"2024-12-02T06:46:45","slug":"macro-gop-du-lieu-nhieu-sheets-excel-vao-1-sheet","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/macro-gop-du-lieu-nhieu-sheets-excel-vao-1-sheet\/","title":{"rendered":"Macro g\u1ed9p d\u1eef li\u1ec7u nhi\u1ec1u sheets Excel v\u00e0o 1 sheet"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-dQf5b79p#1\">\n<p><em>Khi t\u1ed5ng h\u1ee3p d\u1eef li\u1ec7u, b\u1ea1n c\u00f3 nhu c\u1ea7u <a href=\"http:\/\/blog.ezworkapp.com\/cach-tong-hop-nhieu-sheet-excel-vao-mot-sheet-tong-hop.html\"><strong>t\u1ed5ng h\u1ee3p d\u1eef li\u1ec7u t\u1eeb nhi\u1ec1u sheet trong excel<\/strong><\/a> v\u00e0o 1 sheet duy nh\u1ea5t \u0111\u1ec3 l\u00e0m b\u00e1o c\u00e1o. Vi\u1ec7c m\u1edf t\u1eebng sheet ra copy d\u1eef li\u1ec7u s\u1ebd r\u1ea5t t\u1ed1n c\u00f4ng s\u1ee9c v\u00e0 th\u1eddi gian. \u0110\u00e2y l\u00e0 1 b\u00e0i to\u00e1n l\u00fd t\u01b0\u1edfng cho VBA hay Macro trong Excel c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n ho\u00e0n th\u00e0nh 1 c\u00e1ch d\u1ec5 d\u00e0ng.<\/em><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-674d57d428566\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/macro-gop-du-lieu-nhieu-sheets-excel-vao-1-sheet.html#Vi_du_De_bai\" title=\"V\u00ed d\u1ee5 \u0110\u1ec1 b\u00e0i\">V\u00ed d\u1ee5 \u0110\u1ec1 b\u00e0i<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/macro-gop-du-lieu-nhieu-sheets-excel-vao-1-sheet.html#Loi_ket\" title=\"L\u1eddi k\u1ebft\">L\u1eddi k\u1ebft<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Vi_du_De_bai\"><\/span>V\u00ed d\u1ee5 \u0110\u1ec1 b\u00e0i<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Gi\u1ea3 s\u1eed ch\u00fang ta c\u00f3 3 sheets\u00a0v\u1edbi c\u1ea5u tr\u00fac gi\u1ed1ng nhau v\u00e0 ch\u1ec9 kh\u00e1c nhau v\u1ec1 d\u1eef li\u1ec7u nh\u01b0 sau:<\/p>\n<p><a href=\"https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2017\/02\/chi-nhanh-so-1-tong-hop-gop-du-lieu.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-2703 size-medium\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/chi-nhanh-so-1-tong-hop-gop-du-lieu-300x159-1.png\" width=\"300\" height=\"159\" title=\"chi-nhanh-so-1-tong-hop-gop-du-lieu-300x159-1\"><\/a><\/p>\n<p>C\u00e1c b\u01b0\u1edbc \u0111\u1ec3 t\u1ed5ng h\u1ee3p Sheet1, Sheet2, Sheet3 v\u00e0o Sheet \u201cTong Hop\u201d nh\u01b0 sau:<\/p>\n<p><strong>B\u01b0\u1edbc 1<\/strong>: M\u1edf file Tong hop.xlsm<\/p>\n<p><strong>B\u01b0\u1edbc 2<\/strong>: B\u1ea5m t\u1ed5 h\u1ee3p ph\u00edm <strong>ALT + F11<\/strong> \u0111\u1ec3 m\u1edf tr\u00ecnh so\u1ea1n th\u1ea3o VBA<\/p>\n<p><a href=\"https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2017\/02\/Screen-Shot-2017-02-06-at-20.52.56.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-2704\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2017-02-06-at-20-52-56-300x111-1.png\" alt=\"cach-mo-trinh-soan-thao-vba\" width=\"600\" height=\"221\" title=\"screen-shot-2017-02-06-at-20-52-56-300x111-1\"><\/a><\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-62.gif\" title=\"vba101_92019-nho-62\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-151.gif\" title=\"ex101_92019-nho-151\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><strong>B\u01b0\u1edbc 3<\/strong>: M\u1edf Project Explorer: B\u1ea5m v\u00e0o <strong>View &gt; Project Explorer<\/strong><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2017-02-06-at-20-54-03.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-2705 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2017-02-06-at-20-54-03.png\" alt=\"M\u1edf Project Explorer\" width=\"564\" height=\"620\" title=\"screen-shot-2017-02-06-at-20-54-03\"><\/a><\/p>\n<p><strong>B\u01b0\u1edbc 4<\/strong>: Trong c\u1eeda s\u1ed5 Project Explorer, t\u1ea1o 1 Module m\u1edbi<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2017-02-06-at-21-08-45.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2708\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2017-02-06-at-21-08-45.png\" width=\"820\" height=\"636\" title=\"screen-shot-2017-02-06-at-21-08-45\"><\/a><\/p>\n<p><strong>B\u01b0\u1edbc 5<\/strong>: Copy code sau v\u00e0o trong module m\u1edbi v\u1eeba t\u1ea1o ra:<\/p>\n<\/p>\n<div class=\"oembed-gist\">View the code on <a href=\"https:\/\/gist.github.com\/ndthanh\/219feabf26b4a3c6f7e73e6a61510447\">Gist<\/a>.<\/div>\n<p><strong>B\u01b0\u1edbc 6<\/strong>: B\u1ea5m ph\u00edm F5 v\u00e0 chi\u00eam ng\u01b0\u1ee1ng k\u1ebft qu\u1ea3.<\/p>\n<p>\u0110\u1ebfn \u0111\u00e2y b\u1ea1n \u0111\u00e3 c\u00f3 th\u1ec3 b\u1eaft \u0111\u1ea7u t\u00ecm hi\u1ec3u\u00a0nh\u1eefng\u00a0\u0111i\u1ec1u th\u00fa v\u1ecb c\u1ee7a VBA \u0111\u01b0\u1ee3c r\u1ed3i. VBA\u00a0gi\u00fap \u00edch\u00a0r\u1ea5t nhi\u1ec1u trong c\u00f4ng vi\u1ec7c: gi\u00fap b\u1ea1n t\u0103ng t\u1ed1c trong qu\u00e1 tr\u00ecnh x\u1eed l\u00fd tr\u00ean Excel, gi\u00fap l\u1eadp c\u00e1c b\u00e1o c\u00e1o t\u1ef1 \u0111\u1ed9ng, \u0111i\u1ec1u khi\u1ec3n c\u00e1c ch\u01b0\u01a1ng tr\u00ecnh kh\u00e1c nh\u01b0 Word, Power Point, Outlook \u2026 gi\u00fap bi\u1ebfn file Excel c\u1ee7a b\u1ea1n tr\u1edf th\u00e0nh 1 ph\u1ea7n m\u1ec1m chuy\u00ean nghi\u1ec7p \u2026<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Loi_ket\"><\/span><strong>L\u1eddi k\u1ebft<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 h\u1ecdc VBA m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7, c\u00f3 h\u1ec7 th\u1ed1ng, b\u1ea1n h\u00e3y tham gia kho\u00e1 h\u1ecdc\u00a0<a href=\"http:\/\/bit.ly\/2OAUBOg\">VBA101 \u2013 VBA c\u01a1 b\u1ea3n d\u00e0nh cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u<\/a>\u00a0c\u1ee7a h\u1ec7 th\u1ed1ng H\u1ecdc Excel Online. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 nhi\u1ec1u \u01b0u \u0111\u00e3i khi b\u1ea1n \u0111\u0103ng k\u00fd kh\u00f3a h\u1ecdc n\u00e0y. Chi ti\u1ebft xem t\u1ea1i:<\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-62.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":2017,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-2016","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2016","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=2016"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2016\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/2017"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=2016"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=2016"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=2016"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}