{"id":5649,"date":"2024-12-17T04:25:43","date_gmt":"2024-12-17T04:25:43","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/17\/huong-dan-cach-sap-xep-thu-tu-du-lieu-tu-dong-trong-excel-bang-vba\/"},"modified":"2024-12-17T04:25:43","modified_gmt":"2024-12-17T04:25:43","slug":"huong-dan-cach-sap-xep-thu-tu-du-lieu-tu-dong-trong-excel-bang-vba","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/17\/huong-dan-cach-sap-xep-thu-tu-du-lieu-tu-dong-trong-excel-bang-vba\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eafp x\u1ebfp th\u1ee9 t\u1ef1 d\u1eef li\u1ec7u t\u1ef1 \u0111\u1ed9ng trong Excel b\u1eb1ng VBA"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-dQf5b79p#1\">\n<p>\u1ede b\u00e0i h\u1ecdc tr\u01b0\u1edbc, ch\u00fang ta\u00a0\u0111\u00e3 t\u00ecm hi\u1ec3u v\u1ec1 vi\u1ec7c s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng Sort\u00a0\u0111\u1ec3 s\u1eafp x\u1ebfp th\u1ee9 t\u1ef1 d\u1eef li\u1ec7u trong\u00a0Excel.<\/p>\n<p>Xem l\u1ea1i b\u00e0i h\u1ecdc t\u1ea1i:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/sap-xep-du-lieu-theo-nhieu-dieu-kien-trong-excel.html\">S\u1eafp x\u1ebfp d\u1eef li\u1ec7u theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong Excel<\/a><\/p>\n<p>Trong b\u00e0i n\u00e0y, hocexcel.online s\u1ebd gi\u00fap c\u00e1c b\u1ea1n\u00a0\u1ee9ng d\u1ee5ng t\u00ednh n\u0103ng n\u00e0y v\u00e0o VBA\u00a0\u0111\u1ec3 gi\u00fap ch\u00fang ta c\u00f3 th\u1ec3 t\u1ef1\u00a0\u0111\u1ed9ng s\u1eafp x\u1ebfp l\u1ea1i d\u1eef li\u1ec7u m\u1ed7i khi nh\u1eadp th\u00eam d\u1eef li\u1ec7u m\u1edbi v\u00e0o b\u1ea3ng. Ch\u00fang ta t\u00ecm hi\u1ec3u b\u00e0i h\u1ecdc n\u00e0y th\u00f4ng qua b\u00e0i t\u1eadp v\u00ed d\u1ee5 sau:<\/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-6760fd468aefe\" 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\/tu-dong-sap-xep-thu-tu-du-lieu-trong-excel-bang-vba.html#De_bai\" title=\"\u0110\u1ec1 b\u00e0i\">\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\/tu-dong-sap-xep-thu-tu-du-lieu-trong-excel-bang-vba.html#Cach_lam\" title=\"C\u00e1ch l\u00e0m\">C\u00e1ch l\u00e0m<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/tu-dong-sap-xep-thu-tu-du-lieu-trong-excel-bang-vba.html#Buoc_1_Record_Macro_thao_tac_loc_du_lieu\" title=\"B\u01b0\u1edbc 1: Record Macro thao t\u00e1c l\u1ecdc d\u1eef li\u1ec7u\">B\u01b0\u1edbc 1: Record Macro thao t\u00e1c l\u1ecdc d\u1eef li\u1ec7u<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/tu-dong-sap-xep-thu-tu-du-lieu-trong-excel-bang-vba.html#Buoc_2_Nhap_du_lieu_vao_vung_Nhap_moi\" title=\"B\u01b0\u1edbc 2: Nh\u1eadp d\u1eef li\u1ec7u v\u00e0o v\u00f9ng Nh\u1eadp m\u1edbi\">B\u01b0\u1edbc 2: Nh\u1eadp d\u1eef li\u1ec7u v\u00e0o v\u00f9ng Nh\u1eadp m\u1edbi<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/tu-dong-sap-xep-thu-tu-du-lieu-trong-excel-bang-vba.html#Buoc_3_Tao_lenh_Luu_du_lieu\" title=\"B\u01b0\u1edbc 3: T\u1ea1o l\u1ec7nh L\u01b0u d\u1eef li\u1ec7u\">B\u01b0\u1edbc 3: T\u1ea1o l\u1ec7nh L\u01b0u d\u1eef li\u1ec7u<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/tu-dong-sap-xep-thu-tu-du-lieu-trong-excel-bang-vba.html#Buoc_4_Gan_lenh_Luu_du_lieu_vao_nut_Mui_ten\" title=\"B\u01b0\u1edbc 4: G\u00e1n l\u1ec7nh L\u01b0u d\u1eef li\u1ec7u v\u00e0o n\u00fat M\u0169i t\u00ean\">B\u01b0\u1edbc 4: G\u00e1n l\u1ec7nh L\u01b0u d\u1eef li\u1ec7u v\u00e0o n\u00fat M\u0169i t\u00ean<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"De_bai\"><\/span>\u0110\u1ec1 b\u00e0i<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Cho b\u1ea3ng d\u1eef li\u1ec7u sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-12784 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pic06.png\" width=\"1576\" height=\"694\" title=\"pic06\"><\/p>\n<p><strong>Y\u00eau c\u1ea7u<\/strong>: Nh\u1eadp d\u1eef li\u1ec7u v\u00e0o v\u00f9ng I2:M2, sau\u00a0\u0111\u00f3\u00a0\u1ea5n v\u00e0o n\u00fat m\u0169i t\u00ean\u00a0\u0111\u1ec3 l\u01b0u d\u1eef li\u1ec7u v\u00e0o b\u1ea3ng d\u1eef li\u1ec7u A1:F28. Khi l\u01b0u d\u1eef li\u1ec7u v\u00e0o b\u1ea3ng th\u00ec\u00a0\u0111\u1ed3ng th\u1eddi:<\/p>\n<ul>\n<li>X\u00f3a n\u1ed9i dung c\u1ee7a d\u1eef li\u1ec7u\u00a0\u0111\u00e3 nh\u1eadp\u00a0\u1edf I2:M2 (l\u00e0m m\u1edbi d\u1eef li\u1ec7u)<\/li>\n<li>S\u1eafp x\u1ebfp t\u1ef1\u00a0\u0111\u1ed9ng c\u00e1c n\u1ed9i dung trong b\u1ea3ng d\u1eef li\u1ec7u<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Cach_lam\"><\/span>C\u00e1ch l\u00e0m<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Buoc_1_Record_Macro_thao_tac_loc_du_lieu\"><\/span>B\u01b0\u1edbc 1: Record Macro thao t\u00e1c l\u1ecdc d\u1eef li\u1ec7u<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>T\u1ea1i tab Developer, ch\u1ecdn ch\u1ee9c n\u0103ng Record Macro<\/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-207.gif\" title=\"vba101_92019-nho-207\"><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-494.gif\" title=\"ex101_92019-nho-494\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-12596 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pic3.png\" width=\"702\" height=\"534\" title=\"pic3\"><\/p>\n<p>Th\u1ef1c hi\u1ec7n thao t\u00e1c l\u1ecdc d\u1eef li\u1ec7u trong b\u1ea3ng A1:F28<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-12785 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/video-record-macro-sap-xep-nhieu-dk.gif\" width=\"792\" height=\"674\" title=\"video-record-macro-sap-xep-nhieu-dk\"><\/p>\n<p>Sau khi th\u1ef1c hi\u1ec7n thao t\u00e1c tr\u00ean, ch\u00fang ta c\u00f3\u00a0\u0111\u01b0\u1ee3c d\u00f2ng l\u1ec7nh Macro nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-12787 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pic07.png\" width=\"1190\" height=\"494\" title=\"pic07\"><\/p>\n<p>\u00a0<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Buoc_2_Nhap_du_lieu_vao_vung_Nhap_moi\"><\/span>B\u01b0\u1edbc 2: Nh\u1eadp d\u1eef li\u1ec7u v\u00e0o v\u00f9ng Nh\u1eadp m\u1edbi<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ch\u00fang ta c\u00f3 th\u1ec3 nh\u1eadp d\u1eef li\u1ec7u b\u1ea5t k\u1ef3\u00a0\u1edf v\u00f9ng n\u00e0y<\/p>\n<p>V\u00ed d\u1ee5 nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-12788 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pic08-2.png\" width=\"780\" height=\"66\" title=\"pic08-2\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Buoc_3_Tao_lenh_Luu_du_lieu\"><\/span>B\u01b0\u1edbc 3: T\u1ea1o l\u1ec7nh L\u01b0u d\u1eef li\u1ec7u<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u0103n c\u1ee9 theo y\u00eau c\u1ea7u c\u1ee7a\u00a0\u0111\u1ec1 b\u00e0i, ch\u00fang ta c\u00f3 th\u1ec3 x\u00e1c\u00a0\u0111\u1ecbnh\u00a0\u0111\u01b0\u1ee3c tr\u00ecnh t\u1ef1 l\u01b0u d\u1eef li\u1ec7u bao g\u1ed3m:<\/p>\n<ol>\n<li>\u0110\u01b0a d\u1eef li\u1ec7u t\u1eeb v\u00f9ng nh\u1eadp m\u1edbi v\u00e0o B\u1ea3ng d\u1eef li\u1ec7u<\/li>\n<li>X\u00f3a d\u1eef li\u1ec7u\u00a0\u1edf v\u00f9ng nh\u1eadp m\u1edbi<\/li>\n<li>S\u1eafp x\u1ebfp d\u1eef li\u1ec7u trong B\u1ea3ng d\u1eef li\u1ec7u<\/li>\n<\/ol>\n<p>Ch\u00fang ta m\u1edf c\u1eeda s\u1ed5 VBA v\u00e0 t\u1ea1o Sub L\u01b0u d\u1eef li\u1ec7u nh\u01b0 sau:<\/p>\n<p>\u00a0<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-12790 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pic09-2.png\" width=\"402\" height=\"204\" title=\"pic09-2\"><\/p>\n<p>S\u1eed d\u1ee5ng d\u1ea5u nh\u00e1y\u00a0\u0111\u01a1n\u00a0\u0111\u1ec3 gi\u00fap ch\u00fang ta c\u00f3 th\u1ec3 ghi ch\u00fa n\u1ed9i dung, gi\u00fap khi vi\u1ebft v\u00e0\u00a0\u0111\u1ecdc Code trong VBA s\u1ebd d\u1ec5 h\u01a1n<\/p>\n<p>Code L\u01b0u d\u1eef li\u1ec7u v\u00e0o B\u1ea3ng:<\/p>\n<ul>\n<li>T\u00ecm d\u00f2ng cu\u1ed1i trong b\u1ea3ng (c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 t\u00ecm hi\u1ec3u th\u00eam ki\u1ebfn th\u1ee9c v\u1ec1 VBA trong kh\u00f3a h\u1ecdc VBA101 c\u1ee7a th\u1ea7y Thanh)<\/li>\n<\/ul>\n<blockquote>\n<p>Dim DongCuoi As Long<br \/>\nDongCuoi = Sheet1.Cells(Rows.Count, 1).End(xlUp).Row + 1<\/p>\n<\/blockquote>\n<ul>\n<li>L\u01b0u d\u1eef li\u1ec7u v\u00e0o d\u00f2ng cu\u1ed1i<\/li>\n<\/ul>\n<blockquote>\n<p>Sheet1.Range(\u201cA\u201d &amp; DongCuoi &amp; \u201c:\u201d &amp; \u201cF\u201d &amp; DongCuoi).Value = Sheet1.Range(\u201cI2:N2\u201d).Value<\/p>\n<\/blockquote>\n<p>Code x\u00f3a d\u1eef li\u1ec7u\u00a0\u1edf v\u00f9ng nh\u1eadp m\u1edbi (l\u01b0u\u00a0\u00fd l\u00e0\u00a0\u00f4 M2 c\u00f3 ch\u1ee9a c\u00f4ng th\u1ee9c =\u00a0\u0110\u01a1n gi\u00e1 * S\u1ed1 l\u01b0\u1ee3ng, v\u00ec v\u1eady ch\u00fang ta kh\u00f4ng c\u1ea7n x\u00f3a c\u00f4ng th\u1ee9c n\u00e0y)<\/p>\n<blockquote>\n<p>Sheet1.Range(\u201cI2:M2\u201d).ClearContents<\/p>\n<\/blockquote>\n<p>Code s\u1eafp x\u1ebfp d\u1eef li\u1ec7u: ch\u00fang ta g\u1ecdi Macro s\u1eafp x\u1ebfp\u00a0\u0111\u00e3 thu\u00a0\u0111\u01b0\u1ee3c\u00a0\u1edf tr\u00ean<\/p>\n<blockquote>\n<p>Call Macro3<\/p>\n<\/blockquote>\n<p>L\u01b0u\u00a0\u00fd: n\u1ebfu ch\u00fang ta\u00a0\u0111\u1ed5i t\u00ean Macro3 th\u00ec ph\u1ea3i\u00a0\u0111\u1ed5i\u00a0\u1edf Sub Macro3 =&gt; Khi\u00a0\u0111\u00f3 d\u00f2ng l\u1ec7nh Call s\u1ebd g\u1ecdi t\u00ean\u00a0\u0111\u00e3\u00a0\u0111\u01b0\u1ee3c\u00a0\u0111\u1ed5i<\/p>\n<p>* K\u1ebft qu\u1ea3 d\u00f2ng l\u1ec7nh nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-12792 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pic10-1.png\" width=\"926\" height=\"242\" title=\"pic10-1\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Buoc_4_Gan_lenh_Luu_du_lieu_vao_nut_Mui_ten\"><\/span>B\u01b0\u1edbc 4: G\u00e1n l\u1ec7nh L\u01b0u d\u1eef li\u1ec7u v\u00e0o n\u00fat M\u0169i t\u00ean<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li>V\u1ebd n\u00fat m\u0169i t\u00ean b\u1eb1ng c\u00e1ch ch\u1ecdn tab Insert =&gt; Shapes =&gt; Ch\u1ecdn n\u00fat m\u0169i t\u00ean v\u00e0 v\u1ebd ra<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-12793 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pic11-1.png\" width=\"652\" height=\"523\" title=\"pic11-1\"><\/p>\n<ul>\n<li>G\u00e1n macro v\u00e0o Shapes: click chu\u1ed9t ph\u1ea3i v\u00e0o n\u00fat m\u0169i t\u00ean, ch\u1ecdn\u00a0Assign Macro, sau\u00a0\u0111\u00f3 ch\u1ecdn t\u1edbi Macro L\u01b0u d\u1eef li\u1ec7u<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-12794 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/video-record-macro-sap-xep-nhieu-dk-2.gif\" width=\"579\" height=\"601\" title=\"video-record-macro-sap-xep-nhieu-dk-2\"><\/p>\n<ul>\n<li>Sau khi\u00a0\u0111\u00e3 g\u00e1n macro v\u00e0o n\u00fat m\u0169i t\u00ean, ch\u00fang ta th\u1ef1c hi\u1ec7n vi\u1ec7c l\u01b0u d\u1eef li\u1ec7u. V\u00e0\u00a0\u0111\u00e2y l\u00e0 k\u1ebft qu\u1ea3 c\u1ee7a ch\u00fang ta:<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-12795 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pic12-1.png\" width=\"1572\" height=\"640\" title=\"pic12-1\"><\/p>\n<p>D\u00f2ng t\u00f4 m\u00e0u v\u00e0ng ch\u00ednh l\u00e0 d\u00f2ng d\u1eef li\u1ec7u m\u00e0 ch\u00fang ta v\u1eeba th\u00eam m\u1edbi v\u00e0o b\u1ea3ng.<\/p>\n<p>C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y l\u00e0 d\u00f2ng n\u00e0y sau khi th\u00eam\u00a0\u0111\u00e3\u00a0\u0111\u01b0\u1ee3c t\u1ef1\u00a0\u0111\u1ed9ng s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 v\u00e0o trong b\u1ea3ng, ch\u1ee9 kh\u00f4ng ph\u1ea3i xu\u1ea5t hi\u1ec7n\u00a0\u1edf cu\u1ed1i b\u1ea3ng nh\u01b0 th\u00f4ng th\u01b0\u1eddng.<\/p>\n<p>Nh\u01b0 v\u1eady l\u00e0 ch\u00fang ta\u00a0\u0111\u00e3 ho\u00e0n th\u00e0nh\u00a0\u0111\u01b0\u1ee3c y\u00eau c\u1ea7u c\u1ee7a\u00a0\u0111\u1ec1 b\u00e0i r\u1ed3i. N\u1ed9i dung n\u00e0y\u00a0\u0111\u01b0\u1ee3c\u00a0\u1ee9ng d\u1ee5ng r\u1ea5t nhi\u1ec1u trong vi\u1ec7c qu\u1ea3n l\u00fd d\u1eef li\u1ec7u, nh\u1ea5t l\u00e0 nh\u1eefng d\u1eef li\u1ec7u l\u1edbn, c\u1ea7n s\u1eafp x\u1ebfp theo nhi\u1ec1u\u00a0\u0111i\u1ec1u ki\u1ec7n: th\u1eddi gian, ph\u00e2n nh\u00f3m \u2026<\/p>\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. 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-207.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":5650,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-5649","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\/5649","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=5649"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5649\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/5650"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=5649"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=5649"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=5649"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}