{"id":8274,"date":"2024-12-22T04:27:35","date_gmt":"2024-12-22T04:27:35","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/22\/su-dung-autofilter-hieu-qua-hon-voi-vba\/"},"modified":"2024-12-22T04:27:35","modified_gmt":"2024-12-22T04:27:35","slug":"su-dung-autofilter-hieu-qua-hon-voi-vba","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/22\/su-dung-autofilter-hieu-qua-hon-voi-vba\/","title":{"rendered":"S\u1eed d\u1ee5ng AutoFilter hi\u1ec7u qu\u1ea3 h\u01a1n v\u1edbi VBA"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\">N\u1ebfu nh\u01b0 b\u1ea1n th\u01b0\u1eddng xuy\u00ean ph\u1ea3i l\u00e0m\u00a0 c\u00e1c b\u00e1o c\u00e1o chi ti\u1ebft hay l\u00e0m vi\u1ec7c tr\u00ean d\u1eef li\u1ec7u l\u1edbn\u00a0\u0111\u00f2i h\u1ecfi ph\u1ea3i th\u1ed1ng k\u00ea nhanh c\u00e1c ch\u1ec9 ti\u00eau n\u00e0o\u00a0\u0111\u00f3 th\u00ec ch\u1eafc h\u1eb3n kh\u00f4ng c\u00f2n xa l\u1ea1 g\u00ec v\u1edbi c\u00f4ng c\u1ee5 AutoFilter c\u1ee7a\u00a0Excel. S\u1ebd nh\u01b0 th\u1ebf n\u00e0o n\u1ebfu ch\u00fang ta k\u1ebft h\u1ee3p c\u00f4ng c\u1ee5 n\u00e0y v\u1edbi VBA. H\u1ecdc\u00a0Excel Online xin m\u1eddi b\u1ea1n tham kh\u1ea3o b\u00e0i vi\u1ebft.<\/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-6767953658496\" 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-1\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/su-dung-autofilter-hieu-qua-hon-voi-vba.html#Su_dung_AutoFilter_hieu_qua_hon_voi_VBA\" title=\"S\u1eed d\u1ee5ng AutoFilter hi\u1ec7u qu\u1ea3 h\u01a1n v\u1edbi VBA\">S\u1eed d\u1ee5ng AutoFilter hi\u1ec7u qu\u1ea3 h\u01a1n v\u1edbi VBA<\/a>\n<ul class=\"ez-toc-list-level-2\">\n<li class=\"ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/su-dung-autofilter-hieu-qua-hon-voi-vba.html#Khi_AutoFilter_thu_cong\" title=\"Khi AutoFilter th\u1ee7 c\u00f4ng\">Khi AutoFilter th\u1ee7 c\u00f4ng<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/su-dung-autofilter-hieu-qua-hon-voi-vba.html#Khi_ket_hop_voi_VBA\" title=\"Khi k\u1ebft h\u1ee3p v\u1edbi VBA\">Khi k\u1ebft h\u1ee3p v\u1edbi VBA<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h1><span class=\"ez-toc-section\" id=\"Su_dung_AutoFilter_hieu_qua_hon_voi_VBA\"><\/span>S\u1eed d\u1ee5ng AutoFilter hi\u1ec7u qu\u1ea3 h\u01a1n v\u1edbi VBA<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p style=\"text-align: justify\">Khi s\u1eed d\u1ee5ng AutoFilter ch\u00fang ta c\u00f3 th\u1ec3\u00a0c\u00f3 \u0111\u01b0\u1ee3c\u00a0m\u1ed9t c\u00e1i nh\u00ecn chi ti\u1ebft h\u01a1n v\u1ec1 d\u1eef li\u1ec7u t\u01b0\u01a1ng\u00a0\u1ee9ng v\u1edbi ti\u00eau ch\u00ed m\u00e0 ta tr\u00edch l\u1ecdc.\u00a0\u0110\u1ec3\u00a0\u00e1p d\u1ee5ng AutoFilter th\u00ec t\u1ea1i nh\u00f3m Sort &amp; Filter trong th\u1ebb Data b\u1ea1n ch\u1ecdn Filter hay n\u1ebfu nh\u01b0 b\u1ea1n quen d\u00f9ng ph\u00edm t\u1eaft th\u00ec b\u1ea1n c\u00f3 th\u1ec3\u00a0\u1ea5n <strong>Ctrl + Shift + L<\/strong><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Khi_AutoFilter_thu_cong\"><\/span>Khi AutoFilter th\u1ee7 c\u00f4ng<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u1ede\u00a0\u0111\u00e2y m\u00ecnh c\u00f3 b\u1ea3ng t\u1ed5ng h\u1ee3p doanh thu b\u00e1n h\u00e0ng theo c\u00e1c khu v\u1ef1c.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2019\/08\/1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-28589\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1-917x1024-1.png\" width=\"917\" height=\"1024\" title=\"1-917x1024-1\"><\/a><\/p>\n<p style=\"text-align: justify\">khi b\u1ea1n mu\u1ed1n l\u1ecdc\u00a0\u0111\u1ec3 xem th\u00f4ng tin v\u1ec1 s\u1ed1 l\u01b0\u1ee3ng, doanh thu, chi\u1ebft kh\u1ea5u c\u1ee7a t\u1eebng khu v\u1ef1c th\u00ec b\u1ea1n ph\u1ea3i m\u1edf b\u1ed9 l\u1ecdc l\u00ean, ch\u1ecdn t\u1eebng khu v\u1ef1c, sau\u00a0\u0111\u00f3\u00a0\u1ea5n OK \u0111\u1ec3 l\u1ecdc.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-28590\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2-13.png\" width=\"393\" height=\"633\" title=\"2-13\"><\/p>\n<p style=\"text-align: justify\">Khi mu\u1ed1n xem th\u00f4ng tin c\u1ee7a c\u00e1c khu v\u1ef1c l\u1ea1i th\u00ec b\u1ea1n l\u1ea1i l\u00e0m l\u1ea1i thao t\u00e1c tr\u00ean, kh\u00e1 l\u00e0 th\u1ee7 c\u00f4ng ph\u1ea3i kh\u00f4ng n\u00e0o. Th\u1ebf khi k\u1ebft h\u1ee3p v\u1edbi VBA th\u00ec n\u00f3\u00a0s\u1ebd t\u1ef1\u00a0\u0111\u1ed9ng h\u01a1n nh\u01b0 th\u1ebf n\u00e0o?<\/p>\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-752.gif\" title=\"ex101_92019-nho-752\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Khi_ket_hop_voi_VBA\"><\/span>Khi k\u1ebft h\u1ee3p v\u1edbi VBA<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">M\u1ee5c\u00a0\u0111\u00edch s\u1eed d\u1ee5ng VBA\u00a0\u1edf\u00a0\u0111\u00e2y l\u00e0 gi\u00fap cho vi\u1ec7c s\u1eed d\u1ee5ng AutoFilter\u00a0\u0111\u01b0\u1ee3c hi\u1ec7u qu\u1ea3 h\u01a1n, c\u00f3 t\u00ednh t\u1ef1\u00a0\u0111\u1ed9ng cao h\u01a1n hay v\u00ec ph\u1ea3i l\u1ecdc th\u1ee7 c\u00f4ng nh\u01b0 tr\u00ean. C\u00f3 th\u1ec3 b\u1ea1n s\u1ebd mong\u00a0mu\u1ed1n l\u00e0 khi ch\u1ecdn 1 khu v\u1ef1c n\u00e0o\u00a0\u0111\u00f3 th\u00ec d\u1eef li\u1ec7u c\u1ee7a khu v\u1ef1c\u00a0\u0111\u00f3 s\u1ebd\u00a0\u00a0\u0111\u01b0\u1ee3c l\u1ea5y l\u00ean ngay l\u1eadp t\u1ee9c m\u00e0 kh\u00f4ng c\u1ea7n ph\u1ea3i qua c\u00e1c b\u01b0\u1edbc tr\u00ean.<\/p>\n<p style=\"text-align: justify\">B\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o ra 1 danh s\u00e1ch ch\u1ecdn (\u1edf \u0111\u00e2y l\u00e0 \u00f4\u00a0E3)\u00a0g\u1ed3m c\u00e1c khu v\u1ef1c b\u1eb1ng c\u00e1ch lo\u1ea1i b\u1ecf khu v\u1ef1c tr\u00f9ng trong c\u1ed9t khu v\u1ef1c b\u1eb1ng c\u00e1c c\u00f4ng c\u1ee5 hay h\u00e0m h\u1ed7 tr\u1ee3 trong\u00a0Excel, n\u1ebfu nh\u01b0 b\u1ea1n c\u00e0i b\u1ea3n\u00a0Office 365 th\u00ec h\u00e0m <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-su-dung-ham-unique-tu-dong-loc-danh-sach-khong-trung-trong-excel.html\">UNIQUE<\/a>\u00a0 s\u1ebd gi\u00fap b\u1ea1n th\u1ef1c hi\u1ec7n\u00a0\u0111i\u1ec1u n\u00e0y m\u1ed9t c\u00e1ch nhanh ch\u00f3ng, b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o c\u00e1c s\u1eed d\u1ee5ng h\u00e0m n\u00e0y <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-su-dung-ham-unique-tu-dong-loc-danh-sach-khong-trung-trong-excel.html\">t\u1ea1i\u00a0\u0111\u00e2y<\/a><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-28591\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/3-1024x548-1.png\" width=\"1024\" height=\"548\" title=\"3-1024x548-1\"><\/p>\n<p style=\"text-align: justify\">Khi b\u1ea1n thay\u00a0\u0111\u1ed5i\u00a0\u00f4 E3 trong Sheet1 th\u00ec\u00a0\u0111o\u1ea1n Code tr\u00ean s\u1ebd\u00a0\u0111\u01b0\u1ee3c th\u1ef1c thi, n\u00f3 s\u1ebd t\u1ef1 \u0111\u1ed9ng l\u1ecdc ra d\u1eef li\u1ec7u t\u01b0\u01a1ng\u00a0\u1ee9ng v\u1edbi\u00a0\u0111i\u1ec1u ki\u1ec7n tr\u00edch l\u1ecdc\u00a0\u1edf trong\u00a0\u00f4 E3, khi b\u1ea1n thay\u00a0\u0111\u1ed5i khu v\u1ef1c th\u00ec d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n s\u1ebd\u00a0\u0111\u01b0\u1ee3c tr\u00edch l\u1ecdc t\u01b0\u01a1ng\u00a0\u1ee9ng v\u1edbi khu v\u1ef1c\u00a0\u0111\u00f3, n\u1ebfu nh\u01b0\u00a0\u00f4 E3 c\u1ee7a b\u1ea1n l\u00e0 r\u1ed7ng (kh\u00f4ng ch\u1ecdn khu v\u1ef1c n\u00e0o) th\u00ec VBA s\u1ebd th\u1ef1c hi\u1ec7n b\u1ecf l\u1ecdc, tr\u1ea3 v\u1ec1 d\u1eef li\u1ec7u ban\u00a0\u0111\u1ea7u.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-28592\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/4-1024x576-1.png\" width=\"1024\" height=\"576\" title=\"4-1024x576-1\"><\/p>\n<p style=\"text-align: justify\">\u0110o\u1ea1n Code tr\u00ean\u00a0\u0111\u01b0\u1ee3c vi\u1ebft trong Sheet1 v\u1edbi s\u1ef1 ki\u1ec7n\u00a0Worksheet_Change,\u00a0\u0111\u00e2y l\u00e0 c\u00e1ch vi\u1ebft tr\u1ef1c ti\u1ebfp ho\u1eb7c b\u1ea1n c\u00f3 th\u1ec3 vi\u1ebft gi\u00e1n ti\u1ebfp b\u1eb1ng c\u00e1ch t\u1ea1o ra m\u1ed9t\u00a0Module\u00a0\u0111\u1ec3 th\u1ef1c hi\u1ec7n vi\u1ec7c tr\u00edch l\u1ecdc\u00a0\u0111\u00f3 r\u1ed3i t\u1ea1i s\u1ef1 ki\u1ec7n\u00a0Worksheet_Change v\u00e0 g\u1ecdi Sub\u00a0\u0111\u00f3 th\u00ec 2 c\u00e1ch n\u00e0y b\u1ea1n c\u00f3 th\u1ec3 l\u1ef1a ch\u1ecdn\u00a0\u0111\u1ec3\u00a0\u00e1p d\u1ee5ng.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-28593\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/5-1024x362-1.png\" width=\"1024\" height=\"362\" title=\"5-1024x362-1\"><\/p>\n<p style=\"text-align: justify\">Qua b\u00e0i vi\u1ebft n\u00e0y c\u1ee7a H\u1ecdc\u00a0Excel Online hy v\u1ecdng b\u1ea1n\u00a0\u0111\u00e3 c\u00f3 th\u1ec3 t\u1ef1 t\u1ea1o cho m\u00ecnh\u00a0\u0111\u01b0\u1ee3c m\u1ed9t b\u1ed9 l\u1ecdc mang t\u00ednh t\u1ef1\u00a0\u0111\u1ed9ng qu\u00e1 cao h\u01a1n.\u00a0\u0110\u1ec3 c\u00f3 th\u1ec3 ng\u00e0y c\u00e0ng n\u00e2ng cao ki\u1ebfn th\u1ee9c v\u1ec1\u00a0Excel v\u00e0 VBA g\u00f3p ph\u1ea7n t\u0103ng hi\u1ec7u su\u1ea5t trong c\u00f4ng vi\u1ec7c b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o c\u00e1c <a href=\"https:\/\/hocexcel.online\/\">b\u00e0i vi\u1ebft, kho\u00e1 h\u1ecdc t\u1ea1i\u00a0\u0111\u00e2y.<\/a><\/p>\n<hr>\n<p>\u00a0<\/p>\n<p>\u00a0<\/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\/2024\/12\/ex101_92019-nho-752.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":8275,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-8274","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\/8274","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=8274"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8274\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8275"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8274"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8274"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8274"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}