{"id":10564,"date":"2025-01-14T15:56:59","date_gmt":"2025-01-14T15:56:59","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/14\/huong-dan-cach-gop-nhieu-file-excel-thanh-1-file-khong-dung-vba\/"},"modified":"2025-01-14T15:56:59","modified_gmt":"2025-01-14T15:56:59","slug":"huong-dan-cach-gop-nhieu-file-excel-thanh-1-file-khong-dung-vba","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/14\/huong-dan-cach-gop-nhieu-file-excel-thanh-1-file-khong-dung-vba\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch g\u1ed9p nhi\u1ec1u file excel th\u00e0nh 1 file kh\u00f4ng d\u00f9ng VBA"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Vi\u1ec7c g\u1ed9p nhi\u1ec1u file\u00a0Excel th\u00e0nh 1 file r\u1ea5t hay g\u1eb7p ph\u1ea3i trong khi ch\u00fang ta l\u00e0m vi\u1ec7c v\u1edbi\u00a0Excel. V\u00ed d\u1ee5 nh\u01b0 ch\u00fang ta c\u00f3 nhi\u1ec1u file ri\u00eang l\u1ebb t\u1eeb c\u00e1c chi nh\u00e1nh, c\u00e1c b\u1ed9 ph\u1eadn v\u00e0 y\u00eau c\u1ea7u l\u00e0 ch\u00fang ta ph\u1ea3i g\u1ed9p h\u1ebft c\u00e1c file c\u1ee7a t\u1eebng chi nh\u00e1nh, b\u1ed9 ph\u1eadn v\u00e0o chung 1 file l\u1edbn\u00a0\u0111\u1ec3 b\u00e1o c\u00e1o, ph\u00e2n t\u00edch d\u1eef li\u1ec7u. V\u1eady ch\u00fang ta s\u1ebd l\u00e0m vi\u1ec7c n\u00e0y nh\u01b0 th\u1ebf n\u00e0o? Sau\u00a0\u0111\u00e2y H\u1ecdc\u00a0Excel Online s\u1ebd gi\u1edbi hi\u1ec7u v\u1edbi c\u00e1c b\u1ea1n c\u00e1c g\u1ed9p nhi\u1ec1u file\u00a0excel th\u00e0nh 1 file kh\u00f4ng d\u00f9ng VBA.<\/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-6786894aca143\" 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-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-gop-nhieu-file-excel-thanh-1-file-khong-dung-vba.html#1_Phan_tich_yeu_cau_cong_viec\" title=\"1.\u00a0Ph\u00e2n t\u00edch y\u00eau c\u1ea7u c\u00f4ng vi\u1ec7c\">1.\u00a0Ph\u00e2n t\u00edch y\u00eau c\u1ea7u c\u00f4ng vi\u1ec7c<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-gop-nhieu-file-excel-thanh-1-file-khong-dung-vba.html#2_Su_dung_tinh_nang_Move_or_Copy_Sheet\" title=\"2. S\u1eed d\u1ee5ng t\u00ednh n\u0103ng Move\u00a0or Copy Sheet\">2. S\u1eed d\u1ee5ng t\u00ednh n\u0103ng Move\u00a0or Copy Sheet<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"1_Phan_tich_yeu_cau_cong_viec\"><\/span>1.\u00a0Ph\u00e2n t\u00edch y\u00eau c\u1ea7u c\u00f4ng vi\u1ec7c<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Vi\u1ec7c g\u1ed9p nhi\u1ec1u file v\u00e0o 1 file\u00a0excel th\u1ef1c ch\u1ea5t ch\u00ednh l\u00e0 <strong>Copy<\/strong> n\u1ed9i dung c\u1ee7a t\u1eebng Sheet trong nh\u1eefng file nh\u1ecf, file chi nh\u00e1nh\u00a0\u0111\u1ec3 <strong>Paste<\/strong> v\u00e0o file g\u1ed9p, t\u1ed5ng h\u1ee3p.<\/p>\n<p>Vi\u1ec7c n\u00e0y n\u1ebfu kh\u00f4ng l\u00e0m t\u1ef1\u00a0\u0111\u1ed9ng tr\u00ean VBA th\u00ec ch\u00fang ta s\u1ebd ph\u1ea3i th\u1ef1c hi\u1ec7n 1 c\u00e1ch th\u1ee7 c\u00f4ng: M\u1edf t\u1eebng file nh\u1ecf, trong m\u1ed7i file s\u1ebd copy c\u00e1c Sheet\u00a0\u0111\u1ec3\u00a0\u0111\u01b0a v\u00e0o file l\u1edbn. Khi ho\u00e0n th\u00e0nh vi\u1ec7c copy Sheet th\u00ec ch\u00fang ta s\u1ebd\u00a0\u0111\u00f3ng file nh\u1ecf l\u1ea1i, ti\u1ebfp t\u1ee5c m\u1edf file kh\u00e1c v\u00e0 l\u00e0m t\u01b0\u01a1ng t\u1ef1.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"2_Su_dung_tinh_nang_Move_or_Copy_Sheet\"><\/span>2. S\u1eed d\u1ee5ng t\u00ednh n\u0103ng Move\u00a0or Copy Sheet<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u00e2y l\u00e0 1 t\u00ednh n\u0103ng gi\u00fap ch\u00fang ta c\u00f3 th\u1ec3 sao ch\u00e9p nhanh 1 Sheet t\u1eeb file n\u00e0y sang file kh\u00e1c. Vi\u1ec7c sao ch\u00e9p n\u00e0y s\u1ebd bao g\u1ed3m to\u00e0n b\u1ed9 n\u1ed9i dung, \u0111\u1ecbnh d\u1ea1ng v\u00e0 c\u00e1c \u0111\u1ed1i t\u01b0\u1ee3ng c\u00f3 li\u00ean quan t\u1edbi Sheet \u0111\u00f3 (name, data validation, conditional formatting\u2026). C\u00e1ch th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n<p><strong>B\u01b0\u1edbc 1<\/strong>: T\u1ea1i file ch\u1ee9a sheet c\u1ea7n copy (t\u1ea1m g\u1ecdi l\u00e0 file chi nh\u00e1nh), click chu\u1ed9t ph\u1ea3i v\u00e0o Sheet c\u1ea7n copy tr\u00ean thanh Sheet tab\u00a0v\u00e0 ch\u1ecdn <strong>move\u00a0or copy<\/strong><\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/blog.hocexcel.online\/wp-content\/uploads\/imgseo\/doc-merge-multiple-workbooks2.png\" alt=\"doc-merge-multiple-workbooks2\"><\/p>\n<p><strong>B\u01b0\u1edbc 2<\/strong>: H\u1ed9p tho\u1ea1i Move\u00a0or copy m\u1edf ra. Trong h\u1ed9p tho\u1ea1i n\u00e0y ch\u00fang ta s\u1ebd ch\u1ecdn t\u1edbi file t\u1ed5ng h\u1ee3p.<\/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\/2025\/01\/ex101_92019-nho-190.gif\" title=\"ex101_92019-nho-190\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>\u0110\u1ec3 ch\u1ecdn file: Click v\u00e0o m\u1ee5c To Book v\u00e0 ch\u1ecdn\u00a0Workbook c\u1ea7n di chuy\u1ec3n t\u1edbi.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-17760\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/move-sheet-01.png\" width=\"926\" height=\"366\" title=\"move-sheet-01\"><\/p>\n<p><strong>L\u01b0u\u00a0\u00fd<\/strong>: Khi th\u1ef1c hi\u1ec7n thao t\u00e1c move\u00a0or copy \u0111\u1ec3 copy sheet sang file kh\u00e1c th\u00ec ch\u00fang ta c\u1ea7n\u00a0<strong>\u0111\u00e1nh d\u1ea5u v\u00e0o m\u1ee5c Create a copy<\/strong>\u00a0\u0111\u1ec3 ch\u1ec9 th\u1ef1c hi\u1ec7n copy sheet ch\u1ee9 kh\u00f4ng ph\u1ea3i di chuy\u1ec3n Sheet<\/p>\n<p><strong>B\u01b0\u1edbc 3<\/strong>: Sau khi copy c\u1ea7n ch\u00fa\u00a0\u00fd ki\u1ec3m tra l\u1ea1i c\u00e1c n\u1ed9i dung sau:<\/p>\n<ul>\n<li>T\u00ean trong <strong>Name box<\/strong>\u00a0\u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong sheet m\u1edbi copy sang. Vi\u1ec7c gi\u1eef nguy\u00ean c\u00e1c t\u00ean c\u00f3 th\u1ec3 khi\u1ebfn xu\u1ea5t hi\u1ec7n li\u00ean k\u1ebft t\u1edbi b\u00ean ngo\u00e0i file\u00a0excel. Ki\u1ec3m tra trong th\u1ebb Formulas\/Name manager<\/li>\n<li><strong>Conditional formatting<\/strong> trong sheet m\u1edbi copy\u00a0c\u00f3 ch\u1ee9a c\u00f4ng th\u1ee9c li\u00ean k\u1ebft t\u1edbi file chi nh\u00e1nh kh\u00f4ng. Ki\u1ec3m tra trong th\u1ebb Home\/Rule Manager<\/li>\n<li><strong>Data validation<\/strong> c\u00f3 ch\u1ee9a li\u00ean k\u1ebft t\u1edbi b\u00ean ngo\u00e0i file kh\u00f4ng (th\u01b0\u1eddng trong ch\u1ee9c n\u0103ng t\u1ea1o\u00a0List c\u1ee7a Data validation)<\/li>\n<\/ul>\n<p>\u0110\u1ec3 tr\u00e1nh c\u00e1c l\u1ed7i c\u00f3 th\u1ec3 x\u1ea3y ra khi copy Sheet th\u00ec ch\u00fang ta c\u1ea7n ki\u1ec3m tra c\u1ea3 3 n\u1ed9i dung tr\u00ean.<\/p>\n<p>L\u1eb7p l\u1ea1i thao t\u00e1c n\u00e0y v\u1edbi c\u00e1c Sheet kh\u00e1c, file chi nh\u00e1nh kh\u00e1c\u00a0\u0111\u1ec3 ho\u00e0n t\u1ea5t b\u00e1o c\u00e1o<\/p>\n<p>Nh\u01b0 v\u1eady trong file T\u1ed5ng h\u1ee3p ch\u00fang ta\u00a0\u0111\u00e3 c\u00f3 th\u1ec3 c\u00f3\u00a0\u0111\u01b0\u1ee3c c\u00e1c Sheet t\u1ed5ng h\u1ee3p t\u1eeb c\u00e1c chi nh\u00e1nh.<\/p>\n<p>Ngo\u00e0i ra H\u1ecdc Excel Online xin gi\u1edbi thi\u1ec7u v\u1edbi c\u00e1c b\u1ea1n \u201c<strong>Kh\u00f3a h\u1ecdc\u00a0Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi n\u00e2ng cao d\u00e0nh cho ng\u01b0\u1eddi\u00a0\u0111i l\u00e0m<\/strong>\u201c.\u00a0\u0110\u00e2y l\u00e0 1 kh\u00f3a h\u1ecdc r\u1ea5t\u00a0\u0111\u1ea7y\u00a0\u0111\u1ee7 ki\u1ebfn th\u1ee9c v\u00e0 b\u1ed5 tr\u1ee3 r\u1ea5t tuy\u1ec7t v\u1eddi cho b\u1ea1n trong vi\u1ec7c l\u00e0m quen v\u1edbi Excel, s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng c\u1ee5, c\u00e1c h\u00e0m trong\u00a0Excel\u00a0\u0111\u1ec3\u00a0\u0111\u00e1p\u00a0\u1ee9ng y\u00eau c\u1ea7u c\u00f4ng vi\u1ec7c t\u1ed5 ch\u1ee9c, qu\u1ea3n l\u00fd d\u1eef li\u1ec7u v\u00e0 l\u1eadp b\u00e1o c\u00e1o tr\u00ean\u00a0Excel. Chi ti\u1ebft kh\u00f3a h\u1ecdc 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\/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-190.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":10565,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-10564","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\/10564","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=10564"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10564\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/10565"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=10564"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=10564"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=10564"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}