{"id":10634,"date":"2025-01-14T18:40:48","date_gmt":"2025-01-14T18:40:48","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/14\/huong-dan-so-sanh-2-danh-sach-bang-vba\/"},"modified":"2025-01-14T18:40:48","modified_gmt":"2025-01-14T18:40:48","slug":"huong-dan-so-sanh-2-danh-sach-bang-vba","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/14\/huong-dan-so-sanh-2-danh-sach-bang-vba\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn so s\u00e1nh 2 danh s\u00e1ch b\u1eb1ng VBA"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>H\u01b0\u1edbng d\u1eabn so s\u00e1nh 2 danh s\u00e1ch b\u1eb1ng VBA<\/p>\n<p>Ch\u00e0o c\u00e1c b\u1ea1n . V\u1eeba r\u1ed3i b\u1ea1n trang ho\u00e0ng c\u00f3 h\u1ecfi m\u1ed9t c\u00e2u h\u1ecfi kh\u00e1 hay v\u1ec1 c\u00e1ch tr\u00ean Group h\u1ed7 tr\u1ee3 h\u1ecdc vi\u00ean c\u1ee7a kh\u00f3a h\u1ecdc <a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\">VBA<\/a>101 nh\u01b0 sau : (Link download \u1edf cu\u1ed1i b\u00e0i vi\u1ebft nh\u00e9)<\/p>\n<blockquote>\n<p>anh ch\u1ecb \u01a1i, xin cho em h\u1ecfi x\u00edu v\u1edbi \u1ea1.<br \/>\nem c\u00f3 2 c\u1ed9t A v\u00e0 G<br \/>\nkhi l\u1eb7p qua c\u00e1c ph\u1ea7n t\u1eed trong G, \u2014n\u1ebfu \u0111\u00e3 t\u1ed3n t\u1ea1i trong A th\u00ec b\u1ecf qua ,<br \/>\nC\u00f2n ng\u01b0\u1ee3c l\u1ea1i th\u00ec n\u1ea1p ph\u1ea7n t\u1eed \u0111\u00f3 v\u00e0 A .( c\u1ed9t A l\u00e0 g\u1ed3m nh\u1eefng ph\u1ea7n t\u1eed k tr\u00f9ng l\u1eb7p)<br \/>\nanh ch\u1ecb \u01a1i , l\u00e0m sao \u0111\u1ec3 l\u00e0m \u0111\u01b0\u1ee3c c\u00e1i n\u00e0y anh ch\u1ecb nh\u1ec9 .<span class=\"text_exposed_show\"><br \/>\nc\u1ea3m \u01a1n anh ch\u1ecb \u1ea1.<\/span><\/p>\n<\/blockquote>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-16347\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/tranghoang.jpg\" width=\"773\" height=\"719\" title=\"tranghoang\"><\/p>\n<p>\u0110\u00e2y l\u00e0 b\u00e0i kh\u00f4ng qu\u00e1 kh\u00f3 v\u00e0 c\u00f3 r\u1ea5t nhi\u1ec1u c\u00e1ch \u0111\u1ec3 th\u1ef1c hi\u1ec7n. M\u00ecnh s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n m\u1ed9t c\u00e1ch \u0111\u01a1n gi\u1ea3n \u0111\u1ec3 l\u00e0m \u0111i\u1ec1u n\u00e0y, c\u1ee5 th\u1ec3 l\u00e0 s\u1eed d\u1ee5ng <a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\">Marco<\/a> sau \u0111\u00e2y :<\/p>\n<\/p>\n<div class=\"oembed-gist\">View the code on <a href=\"https:\/\/gist.github.com\/TGDUY\/3d4eb326ce4c1cf58b6af360dd0e725a\">Gist<\/a>.<\/div>\n<p>Kh\u00e1 \u0111\u01a1n gi\u1ea3n \u0111\u00fang kh\u00f4ng n\u00e0o. Ch\u00fac b\u1ea1n h\u1ecdc t\u1ed1t v\u1edbi <a href=\"https:\/\/hocexcel.online\/\">Hocexcel.online<\/a><\/p>\n<p>N\u1ebfu v\u1eabn ch\u01b0a hi\u1ec3u vui l\u00f2ng xem video nh\u00e9.<\/p>\n<iframe loading=\"lazy\" title=\"H\u01b0\u1edbng d\u1eabn so s\u00e1nh 2 danh s\u00e1ch b\u1eb1ng VBA\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/Ev8AikqVvzo?feature=oembed\" frameborder allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe>\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\/2025\/01\/ex101_92019-nho-200.gif\" title=\"ex101_92019-nho-200\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>B\u1ea1n download t\u1ea1i \u0111\u00e2y :<\/p>\n<p>B\u1ea1n ch\u01b0a bi\u1ebft c\u00e1ch t\u1ef1 \u0111\u1ed9ng h\u00f3a excel \u0111\u1ec3 t\u1eadn d\u1ee5ng t\u1ed1i \u0111a kh\u1ea3 n\u0103ng c\u1ee7a n\u00f3 th\u00ec b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o kh\u00f3a h\u1ecdc sau \u0111\u00e2y \u0111\u1ec3 chinh ph\u1ee5c <a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\">Excel<\/a> \u0111\u1ec9nh cao.<\/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\/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\/2025\/01\/ex101_92019-nho-200.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":10635,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-10634","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10634","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=10634"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10634\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/10635"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=10634"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=10634"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=10634"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}