{"id":5742,"date":"2024-12-20T20:32:34","date_gmt":"2024-12-20T20:32:34","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/20\/excel-vba-tao-sheetform-phieu-thu-phieu-chi-phan-3\/"},"modified":"2024-12-20T20:32:34","modified_gmt":"2024-12-20T20:32:34","slug":"excel-vba-tao-sheetform-phieu-thu-phieu-chi-phan-3","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/20\/excel-vba-tao-sheetform-phieu-thu-phieu-chi-phan-3\/","title":{"rendered":"Excel VBA: T\u1ea1o SheetForm Phi\u1ebfu Thu, Phi\u1ebfu Chi \u2013 Ph\u1ea7n 3"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-dQf5b79p#1\">\n<p>Ch\u00e0o c\u00e1c b\u1ea1n,<\/p>\n<p>Khi\u00a0 s\u1eed d\u1ee5ng VBA trong\u00a0excel ,\u00a0 ch\u00fang ta th\u01b0\u1eddng ngh\u0129 t\u1edbi vi\u1ec7c s\u1eed d\u1ee5ng\u00a0userform\u00a0\u0111\u1ec3 t\u1ea1o form nh\u1eadp d\u1eef li\u1ec7u. Nh\u01b0ng vi\u1ec7c thi\u1ebft l\u1eadp\u00a0userform th\u01b0\u1eddng kh\u00e1 ph\u1ee9c t\u1ea1p v\u00e0 s\u1eed d\u1ee5ng nhi\u1ec1u code.\u00a0\u0110\u1ed1i v\u1edbi nh\u1eefng b\u1ea1n m\u1edbi ti\u1ebfp c\u1eadn v\u1ec1 VBA th\u00ec vi\u1ec7c s\u1eed d\u1ee5ng\u00a0userform g\u1eb7p nhi\u1ec1u kh\u00f3 kh\u0103n.<\/p>\n<p>Trong b\u00e0i vi\u1ebft n\u00e0y\u00a0 m\u00ecnh s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng SheetForm (form t\u1ea1o tr\u00ean Sheet)\u00a0\u0111\u1ec3 s\u1eed d\u1ee5ng t\u01b0\u01a1ng t\u1ef1 nh\u01b0\u00a0userform. Ph\u1ea1m vi b\u00e0i vi\u1ebft g\u1ed3m:<\/p>\n<ul>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/excel-vba-tao-sheetform-phieu-thu-phieu-chi.html\">B\u00e0i 1: X\u00e2y d\u1ef1ng c\u1ea5u tr\u00fac SheetForm<\/a><\/li>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/excel-vba-tao-sheetform-phieu-thu-phieu-chi-phan-2.html\">B\u00e0i 2: Vi\u1ebft Code VBA cho thao t\u00e1c M\u1edf v\u00e0\u00a0\u0110\u00f3ng SheetForm<\/a><\/li>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/excel-vba-tao-sheetform-phieu-thu-phieu-chi-phan-3.html\">B\u00e0i 3: Vi\u1ebft Code VBA cho thao t\u00e1c L\u00e0m m\u1edbi SheetForm<\/a><\/li>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/excel-vba-tao-sheetform-phieu-thu-phieu-chi-phan-4.html\">B\u00e0i 4: Vi\u1ebft Code VBA cho thao t\u00e1c L\u01b0u SheetForm<\/a><\/li>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/excel-vba-tao-sheetform-phieu-thu-phieu-chi-phan-5.html\">B\u00e0i 5: B\u1eaby l\u1ed7i trong SheetForm v\u00e0\u00a0\u0111\u00e1nh gi\u00e1 v\u1ec1 ph\u01b0\u01a1ng ph\u00e1p n\u00e0y<\/a><\/li>\n<\/ul>\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-6765d461cc28b\" 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\/excel-vba-tao-sheetform-phieu-thu-phieu-chi-phan-3.html#Bai_3_Viet_code_VBA_cho_thao_tac_Lam_moi_SheetForm\" title=\"B\u00e0i 3: Vi\u1ebft code VBA cho thao t\u00e1c L\u00e0m m\u1edbi SheetForm\">B\u00e0i 3: Vi\u1ebft code VBA cho thao t\u00e1c L\u00e0m m\u1edbi SheetForm<\/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-2\" href=\"https:\/\/blog.hocexcel.online\/excel-vba-tao-sheetform-phieu-thu-phieu-chi-phan-3.html#Tao_nut_lenh\" title=\"T\u1ea1o n\u00fat l\u1ec7nh\">T\u1ea1o n\u00fat l\u1ec7nh<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/excel-vba-tao-sheetform-phieu-thu-phieu-chi-phan-3.html#Xay_dung_quy_trinh\" title=\"X\u00e2y d\u1ef1ng quy tr\u00ecnh\">X\u00e2y d\u1ef1ng quy tr\u00ecnh<\/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\/excel-vba-tao-sheetform-phieu-thu-phieu-chi-phan-3.html#Lap_so_phieu_tu_dong\" title=\"L\u1eadp s\u1ed1 phi\u1ebfu t\u1ef1\u00a0\u0111\u1ed9ng\">L\u1eadp s\u1ed1 phi\u1ebfu t\u1ef1\u00a0\u0111\u1ed9ng<\/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\/excel-vba-tao-sheetform-phieu-thu-phieu-chi-phan-3.html#Viet_code_VBA\" title=\"Vi\u1ebft code VBA\">Vi\u1ebft code VBA<\/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\/excel-vba-tao-sheetform-phieu-thu-phieu-chi-phan-3.html#Gan_lenh_Macro_vao_nut_lenh\" title=\"G\u00e1n l\u1ec7nh Macro v\u00e0o n\u00fat l\u1ec7nh\">G\u00e1n l\u1ec7nh Macro v\u00e0o n\u00fat l\u1ec7nh<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/excel-vba-tao-sheetform-phieu-thu-phieu-chi-phan-3.html#Cau_hoi_sau_bai_hoc\" title=\"C\u00e2u h\u1ecfi sau b\u00e0i h\u1ecdc\">C\u00e2u h\u1ecfi sau b\u00e0i h\u1ecdc<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Bai_3_Viet_code_VBA_cho_thao_tac_Lam_moi_SheetForm\"><\/span>B\u00e0i 3: Vi\u1ebft code VBA cho thao t\u00e1c L\u00e0m m\u1edbi SheetForm<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Tao_nut_lenh\"><\/span>T\u1ea1o n\u00fat l\u1ec7nh<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ch\u00fang ta v\u1ebd 1 n\u00fat l\u1ec7nh c\u00f3 t\u00ean <strong>L\u00e0m m\u1edbi <\/strong>trong sheet Phieu_thu (\u0111\u1ec3 t\u00ecm hi\u1ec3u chi ti\u1ebft c\u00e1ch v\u1ebd vui l\u00f2ng xem\u00a0\u1edf b\u00e0i 2)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-11972 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pic01-2-1.png\" width=\"605\" height=\"430\" title=\"pic01-2-1\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Xay_dung_quy_trinh\"><\/span>X\u00e2y d\u1ef1ng quy tr\u00ecnh<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>X\u00e2y d\u1ef1ng quy tr\u00ecnh ch\u00ednh l\u00e0 vi\u1ec7c di\u1ec5n gi\u1ea3i to\u00e0n b\u1ed9 di\u1ec5n bi\u1ebfn c\u1ee7a c\u00e2u l\u1ec7nh b\u1eb1ng l\u1eddi.<\/p>\n<p>C\u1ee5 th\u1ec3:<\/p>\n<div class=\"code-block code-block-3\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<p>D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n<p><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-503.gif\" title=\"ex101_92019-nho-503\"><br \/>\n<\/a>\n<\/div>\n<\/div>\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-211.gif\" title=\"vba101_92019-nho-211\"><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-503.gif\" title=\"ex101_92019-nho-503\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ul>\n<li>\u0110\u1ed1i t\u01b0\u1ee3ng s\u1ed1 phi\u1ebfu: Khi l\u00e0m m\u1edbi s\u1ebd c\u1eadp nh\u1eadt s\u1ed1 phi\u1ebfu t\u1ef1\u00a0\u0111\u1ed9ng<\/li>\n<li>C\u00e1c\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng kh\u00e1c: Khi l\u00e0m m\u1edbi s\u1ebd l\u00e0m tr\u1ed1ng d\u1eef li\u1ec7u t\u1ea1i c\u00e1c n\u1ed9i dung\u00a0\u0111\u00f3.<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Lap_so_phieu_tu_dong\"><\/span>L\u1eadp s\u1ed1 phi\u1ebfu t\u1ef1\u00a0\u0111\u1ed9ng<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u00e2y l\u00e0 m\u1ed9t n\u1ed9i dung ph\u1ee9c t\u1ea1p. Ph\u1ee9c t\u1ea1p ngay c\u1ea3 trong SheetForm hay\u00a0UserForm. B\u1edfi v\u00ec n\u00f3 ph\u1ee5 thu\u1ed9c r\u1ea5t nhi\u1ec1u y\u1ebfu t\u1ed1, v\u00e0 t\u00ednh bi\u1ec7n\u00a0\u0111\u1ed9ng cao:<\/p>\n<ul>\n<li>Ph\u1ee5 thu\u1ed9c d\u1ea1ng s\u1ed1 phi\u1ebfu: V\u00ed d\u1ee5 d\u1ea1ng PT01 hay PT001 l\u00e0 1 d\u1ea1ng, nh\u01b0ng PT01\/2017 l\u1ea1i l\u00e0 d\u1ea1ng kh\u00e1c. Kh\u00e1c\u00a0\u1edf ch\u1ed7 ph\u1ea3i bi\u1ec7n lu\u1eadn th\u00eam gi\u00e1 tr\u1ecb s\u1ed1 n\u0103m l\u1eadp phi\u1ebfu m\u1ed9t c\u00e1ch t\u1ef1\u00a0\u0111\u1ed9ng.<\/li>\n<li>Ph\u1ee5 thu\u1ed9c c\u1ea5u tr\u00fac d\u1eef li\u1ec7u l\u01b0u trong B\u1ea3ng k\u00ea: N\u1ebfu b\u1ea3ng k\u00ea l\u01b0u d\u01b0\u1edbi d\u1ea1ng M\u1ed7i phi\u1ebfu 1 d\u00f2ng th\u00ec\u00a0\u0111\u1ebfm th\u1ee9 t\u1ef1 li\u00ean t\u1ee5c\u00a0 m\u1ed9t ki\u1ec3u (th\u01b0\u1eddng l\u00e0 t\u00ecm gi\u00e1 tr\u1ecb s\u1ed1 phi\u1ebfu l\u1edbn nh\u1ea5t\u00a0\u0111ang l\u01b0u r\u1ed3i c\u1ed9ng th\u00eam 1), nh\u01b0ng n\u1ebfu l\u01b0u d\u01b0\u1edbi d\u1ea1ng 1 phi\u1ebfu c\u00f3 nhi\u1ec1u d\u00f2ng th\u00ec ph\u1ea3i\u00a0\u0111\u1ebfm l\u1ea7n xu\u1ea5t hi\u1ec7n c\u1ee7a m\u1ed7i phi\u1ebfu ch\u1ec9 duy nh\u1ea5t 1 l\u1ea7n\u2026<\/li>\n<\/ul>\n<p>Trong t\u1eebng m\u1ee5c\u00a0\u00a0\u0111\u00edch c\u1ee5 th\u1ec3 ch\u00fang ta s\u1ebd c\u00f3 c\u00e1ch bi\u1ec7n lu\u1eadn v\u00e0 x\u00e2y d\u1ef1ng s\u1ed1 phi\u1ebfu t\u1ef1\u00a0\u0111\u1ed9ng ph\u00f9 h\u1ee3p.<\/p>\n<p>Trong ph\u1ea1m vi b\u00e0i vi\u1ebft n\u00e0y, m\u00ecnh xin\u00a0\u0111\u01b0a ra d\u1ea1ng\u00a0\u0111\u01a1n gi\u1ea3n nh\u1ea5t l\u00e0 d\u1ea1ng PT01 v\u00e0 m\u1ed7i phi\u1ebfu l\u01b0u 1 d\u00f2ng trong b\u1ea3ng k\u00ea (v\u00ec seri b\u00e0i vi\u1ebft thu\u1ed9c m\u1ee9c\u00a0\u0111\u1ed9 c\u01a1 b\u1ea3n v\u00e0\u00a0\u0111\u01a1n gi\u1ea3n nh\u1ea5t gi\u00fap c\u00e1c b\u1ea1n m\u1edbi h\u1ecdc VBA hi\u1ec3u, v\u00e0 t\u1eadp trung v\u00e0o VBA)<\/p>\n<p>C\u00f4ng th\u1ee9c t\u00ednh s\u1ed1 phi\u1ebfu t\u1ef1\u00a0\u0111\u1ed9ng:<\/p>\n<p>\u2013 T\u00ednh logic:<\/p>\n<ul>\n<li>B\u1eaft\u00a0\u0111\u1ea7u b\u1eb1ng k\u00fd t\u1ef1 \u201cPT\u201d t\u1ee9c l\u00e0 Phi\u1ebfu thu<\/li>\n<li>S\u1ed1 th\u1ee9 t\u1ef1 phi\u1ebfu\u00a0\u0111\u01b0\u1ee3c\u00a0\u0111\u1ebfm b\u1eb1ng T\u1ed5ng s\u1ed1 phi\u1ebfu\u00a0\u0111\u00e3 l\u01b0u trong b\u1ea3ng k\u00ea v\u00e0 c\u1ed9ng th\u00eam 1 gi\u00e1 tr\u1ecb.<\/li>\n<\/ul>\n<p>\u2013 H\u00e0m, c\u00f4ng th\u1ee9c\u00a0Excel\u00a0\u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng<\/p>\n<blockquote>\n<p>=\u201dPT\u201d&amp;TEXT(COUNTIF(Bang_Ke!$A$4:$A$100,\u201dThu\u201d)+1,\u201d0#\u201d)<\/p>\n<\/blockquote>\n<p>Bang_Ke!$A$4:$A$100 l\u00e0 v\u00f9ng Lo\u1ea1i phi\u1ebfu<\/p>\n<p>COUNTIF(Bang_Ke!$A$4:$A$100,\u201dThu\u201d) l\u00e0 ch\u1ec9\u00a0\u0111\u1ebfm\u00a0nh\u1eefng d\u00f2ng phi\u1ebfu c\u00f3 Lo\u1ea1i l\u00e0 Thu<\/p>\n<p>TEXT(COUNTIF(Bang_Ke!$A$4:$A$100,\u201dThu\u201d)+1,\u201d0#\u201d) l\u00e0 t\u1ed5ng s\u1ed1 phi\u1ebfu c\u00f3 lo\u1ea1i l\u00e0 thu s\u1ebd c\u1ed9ng th\u00eam 1\u00a0\u0111\u01a1n v\u1ecb, v\u00e0\u00a0\u0111\u01b0\u1ee3c vi\u1ebft d\u01b0\u1edbi d\u1ea1ng s\u1ed1 c\u00f3 ch\u1eef s\u1ed1 o\u00a0\u1edf\u00a0\u0111\u1ea7u n\u1ebfu s\u1ed1\u00a0\u0111\u00f3 ch\u1ec9 c\u00f3 1 ch\u1eef s\u1ed1.<\/p>\n<p>=&gt; T\u1ea1o 1 sheet l\u00e0 Sheet \u201c\u0110i\u1ec1u ki\u1ec7n\u201d,\u00a0\u0111\u1eb7t c\u00f4ng th\u1ee9c t\u00ednh s\u1ed1 phi\u1ebfu t\u1ef1\u00a0\u0111\u1ed9ng v\u00e0o\u00a0\u00f4 b\u1ea5t k\u1ef3 trong sheet\u00a0\u0111\u00f3, v\u00ed d\u1ee5\u00a0\u00f4 C3<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-11973 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pic02-2-1.png\" width=\"970\" height=\"178\" title=\"pic02-2-1\"><\/p>\n<blockquote>\n<p>\u0110\u1eebng b\u1ecf l\u1ee1:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\">L\u1edbp h\u1ecdc Excel \u1edf H\u00e0 N\u1ed9i<\/a>\u00a0c\u00f9ng c\u00e1c chuy\u00ean gia<\/p>\n<\/blockquote>\n<h3><span class=\"ez-toc-section\" id=\"Viet_code_VBA\"><\/span>Vi\u1ebft code VBA<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>M\u1edf c\u1eeda s\u1ed5 VBA (ph\u00edm t\u1eaft Alt + F11), t\u1ea1o 1 Sub c\u00f3 t\u00ean l\u00e0 Lam_Moi_Phieu_Thu<\/p>\n<p>N\u1ed9i dung c\u1ee7a Sub\u00a0\u0111\u01b0\u1ee3c\u00a0 bi\u1ec3u di\u1ec5n nh\u01b0 sau<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-11976 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/viet-code.gif\" width=\"628\" height=\"254\" title=\"viet-code\"><\/p>\n<p>Sub Lam_Moi_Phieu_Thu()<br \/>\n\u2018Thuc hien tai sheet Phieu_Thu<br \/>\nWith Sheet2<br \/>\n\u2018Lay so phieu moi<br \/>\n.Cells(4, 2).Value = Sheet3.Cells(3, 3).Value<br \/>\n\u2018Xoa du lieu o nhung noi dung khac<br \/>\n.Range(\u201cB6:B14\u201d).ClearContents<br \/>\nEnd With<br \/>\nEnd Sub<\/p>\n<p>*** N\u1ed9i dung code\u00a0\u0111\u01b0\u1ee3c hi\u1ec3u nh\u01b0 sau:<\/p>\n<ul>\n<li>V\u00ec th\u1ef1c hi\u1ec7n t\u1ea1i sheet Phi\u1ebfu thu, v\u00ec v\u1eady ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng\u00a0With Sheet 2 \u2026. End\u00a0With\u00a0\u0111\u1ec3 gi\u1edbi h\u1ea1n n\u1ed9i dung trong sheet2, v\u00e0 kh\u00f4ng c\u1ea7n bi\u1ec3u di\u1ec5n qu\u00e1 nhi\u1ec1u t\u00ean Sheet2 trong c\u00e2u l\u1ec7nh.<\/li>\n<li>.Cells(4,2).value\u00a0 \u00a0 \u00a0 l\u00e0 gi\u00e1 tr\u1ecb t\u1ea1i\u00a0\u00f4 c\u00f3 t\u1ecda\u00a0\u0111\u1ed9 h\u00e0ng 4, c\u1ed9t 2 (\u00f4 B4) trong sheet Phi\u1ebfu thu<\/li>\n<li>Sheet3.cells(3,3).value\u00a0 \u00a0 \u00a0 l\u00e0 gi\u00e1 tr\u1ecb t\u1ea1i\u00a0\u00f4 c\u00f3 t\u1ecda\u00a0\u0111\u1ed9 h\u00e0ng 3, c\u1ed9t 3 (\u00f4 C3) trong sheet3 (sheet\u00a0\u0110i\u1ec1u ki\u1ec7n),\u00a0\u0111\u00e2y ch\u00ednh l\u00e0\u00a0\u00f4 c\u00f3 c\u00f4ng th\u1ee9c s\u1ed1 phi\u1ebfu t\u1ef1\u00a0\u0111\u1ed9ng<\/li>\n<li>.Cells(4, 2).Value = Sheet3.Cells(3, 3).Value\u00a0 \u00a0 \u00a0 \u00a0\u0111\u01b0\u1ee3c\u00a0 hi\u1ec3u l\u00e0 l\u1ea5y gi\u00e1 tr\u1ecb c\u1ee7a\u00a0\u00f4 s\u1ed1 phi\u1ebfu t\u1ef1\u00a0\u0111\u1ed9ng trong sheet\u00a0\u0110i\u1ec1u ki\u1ec7n\u00a0\u0111\u01b0a v\u00e0o gi\u00e1 tr\u1ecb\u00a0\u00f4 S\u1ed1 phi\u1ebfu trong sheet phi\u1ebfu thu<\/li>\n<li>.Range(\u201cB6:B14\u201d).ClearContents\u00a0 \u00a0 \u00a0 l\u00e0 x\u00f3a d\u1eef li\u1ec7u trong v\u00f9ng t\u1eeb B6\u00a0\u0111\u1ebfn B14 trong sheet Phi\u1ebfu thu (v\u00f9ng n\u00e0y t\u01b0\u01a1ng\u00a0\u1ee9ng v\u1edbi n\u1ed9i dung nh\u1eadp d\u1eef li\u1ec7u c\u1ee7a c\u00e1c ch\u1ec9 ti\u00eau c\u00f2n l\u1ea1i).<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Gan_lenh_Macro_vao_nut_lenh\"><\/span>G\u00e1n l\u1ec7nh Macro v\u00e0o n\u00fat l\u1ec7nh<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ch\u1ecdn ch\u1ee9c n\u0103ng\u00a0Assign Macro cho n\u00fat l\u1ec7nh L\u00e0m m\u1edbi, ch\u1ecdn macro Lam_Moi_Phieu_Thu<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-11977 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pic03-2-1.png\" width=\"1182\" height=\"550\" title=\"pic03-2-1\"><\/p>\n<p>\u2014<\/p>\n<p>Nh\u01b0 v\u1eady ch\u00fang ta\u00a0\u0111\u00e3 ho\u00e0n th\u00e0nh xong thao t\u00e1c t\u1ea1o n\u00fat l\u1ec7nh l\u00e0m m\u1edbi phi\u1ebfu thu.<\/p>\n<blockquote>\n<p>Xem ngay:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-excel-ke-toan.html\">h\u1ecdc Excel k\u1ebf to\u00e1n \u01a1\u0309 \u0111\u00e2u<\/a>?<\/p>\n<\/blockquote>\n<p>C\u1ea3m\u00a0\u01a1n c\u00e1c b\u1ea1n\u00a0\u0111\u00e3 ch\u00fa\u00a0\u00fd theo d\u00f5i.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cau_hoi_sau_bai_hoc\"><\/span>C\u00e2u h\u1ecfi sau b\u00e0i h\u1ecdc<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>T\u1ea1i sao kh\u00f4ng l\u00e0m th\u1eb3ng c\u00f4ng th\u1ee9c v\u00e0o\u00a0\u00f4 B4 trong Phi\u1ebfu thu m\u00e0 ph\u1ea3i th\u00f4ng qua sheet DK\u00a0\u1edf\u00a0\u00f4 C3?<\/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<p>D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n<p><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-503.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":5743,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-5742","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\/5742","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=5742"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5742\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/5743"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=5742"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=5742"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=5742"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}