{"id":4998,"date":"2024-12-08T21:46:22","date_gmt":"2024-12-08T21:46:22","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/08\/noi-du-lieu-tren-nhieu-dong-excel-theo-nhom-bang-vba\/"},"modified":"2024-12-08T21:46:22","modified_gmt":"2024-12-08T21:46:22","slug":"noi-du-lieu-tren-nhieu-dong-excel-theo-nhom-bang-vba","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/08\/noi-du-lieu-tren-nhieu-dong-excel-theo-nhom-bang-vba\/","title":{"rendered":"N\u1ed1i d\u1eef li\u1ec7u tr\u00ean nhi\u1ec1u d\u00f2ng Excel theo nh\u00f3m b\u1eb1ng VBA"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-dQf5b79p#1\">\n<p>T\u1eeb b\u00e0i vi\u1ebft \u00a0<strong><a href=\"http:\/\/blog.ezworkapp.com\/noi-du-lieu-tren-nhieu-dong-excel-theo-nhom.html\">N\u1ed1i d\u1eef li\u1ec7u tr\u00ean nhi\u1ec1u d\u00f2ng Excel theo nh\u00f3m<\/a>\u00a0c\u1ee7a <a href=\"http:\/\/blog.ezworkapp.com\/author\/dtnguyen\">dtnguyen<\/a>\u00a0.M\u00ecnh s\u1ebd h\u01b0\u1edbng d\u1eabn cho b\u1ea1n th\u00eam m\u1ed9t c\u00e1ch n\u1eefa l\u00e0 d\u00f9ng VBA \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng v\u1edbi d\u1eef li\u1ec7u l\u1edbn ch\u00fat : \u1edf \u0111\u00e2y l\u00e0 169.000 d\u00f2ng<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-16859\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/noi-du-lieu-tren-nhieu-dong-excel-theo-nhom-bang-vba1.jpg\" width=\"718\" height=\"588\" title=\"noi-du-lieu-tren-nhieu-dong-excel-theo-nhom-bang-vba1\"><\/p>\n<p><strong>Ta s\u1eed d\u1ee5ng m\u1ed9t \u0111o\u1ea1n code r\u1ea5t \u0111\u01a1n gi\u1ea3n nh\u01b0 sau :<\/strong><\/p>\n<\/p>\n<div class=\"oembed-gist\">View the code on <a href=\"https:\/\/gist.github.com\/TGDUY\/d3c49c57c6e8235507e041fcb07fb8b6\">Gist<\/a>.<\/div>\n<p><strong>V\u00e0 \u0111\u00e2y l\u00e0 k\u1ebft qu\u1ea3 xu\u1ea5t ra ch\u1ec9 trong nh\u00e1y m\u1eaft<\/strong> (Kh\u00f4ng \u0111\u1ebfn 1s)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-16860\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/noi-du-lieu-tren-nhieu-dong-excel-theo-nhom-bang-vba2.jpg\" width=\"1361\" height=\"723\" title=\"noi-du-lieu-tren-nhieu-dong-excel-theo-nhom-bang-vba2\"><\/p>\n<p><strong>B\u1ea1n vui l\u00f2ng xem video b\u00ean d\u01b0\u1edbi \u0111\u1ec3 r\u00f5 h\u01a1n v\u1ec1 s\u1ee9c m\u1ea1nh c\u1ee7a VBA:<\/strong><\/p>\n<iframe loading=\"lazy\" title=\"N\u1ed1i d\u1eef li\u1ec7u tr\u00ean nhi\u1ec1u d\u00f2ng Excel theo nh\u00f3m b\u1eb1ng VBA\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/B8qJD637Fd0?feature=oembed\" frameborder allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe>\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-162.gif\" title=\"vba101_92019-nho-162\"><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-416.gif\" title=\"ex101_92019-nho-416\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><strong>T\u1ea3i file m\u1eabu trong video v\u1ec1 t\u1ea1i \u0111\u00e2y :<\/strong><\/p>\n<p><strong>Ch\u00fac b\u1ea1n h\u1ecdc t\u1ed1t c\u00f9ng <a href=\"https:\/\/hocexcel.online\/\">Hocexcel.online<\/a>!<\/strong><\/p>\n<hr>\n<p>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<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.\u00a0Th\u00f4ng tin chi ti\u1ebft v\u1ec1 kh\u00f3a h\u1ecdc, b\u1ea1n t\u00ecm hi\u1ec3u th\u00eam t\u1ea1i \u0111\u00e2y:<\/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-162.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":4999,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-4998","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\/4998","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=4998"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4998\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/4999"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=4998"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=4998"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=4998"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}