{"id":8219,"date":"2024-12-22T04:15:21","date_gmt":"2024-12-22T04:15:21","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/22\/tong-hop-du-lieu-tu-nhieu-file-excel-vao-1-file-khong-can-mo-file\/"},"modified":"2024-12-22T04:15:21","modified_gmt":"2024-12-22T04:15:21","slug":"tong-hop-du-lieu-tu-nhieu-file-excel-vao-1-file-khong-can-mo-file","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/22\/tong-hop-du-lieu-tu-nhieu-file-excel-vao-1-file-khong-can-mo-file\/","title":{"rendered":"T\u1ed5ng h\u1ee3p d\u1eef li\u1ec7u t\u1eeb nhi\u1ec1u file excel v\u00e0o 1 file kh\u00f4ng c\u1ea7n m\u1edf file"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-dQf5b79p#1\">\n<p>Trong c\u00f4ng vi\u1ec7c, nh\u1ea5t l\u00e0 nh\u1eefng c\u00f4ng vi\u1ec7c li\u00ean quan \u0111\u1ebfn d\u1eef li\u1ec7u nh\u01b0 ng\u00e2n h\u00e0ng, t\u00e0i ch\u00ednh, k\u1ebf to\u00e1n v\u00e0 c\u00e1c ng\u00e0nh nghi\u00ean c\u1ee9u, c\u00e1c b\u1ea1n \u0111\u00e3 g\u1eb7p ph\u1ea3i tr\u01b0\u1eddng h\u1ee3p c\u1ea7n ph\u1ea3i t\u1ed5ng h\u1ee3p d\u1eef li\u1ec7u t\u1eeb nhi\u1ec1u file Excel kh\u00e1c nhau nh\u01b0ng c\u00f3 c\u1ea5u tr\u00fac gi\u1ed1ng nhau v\u00e0o c\u00f9ng 1 file master. Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 c\u00f3 th\u1ec3 <strong>t\u1ed5ng h\u1ee3p d\u1eef li\u1ec7u t\u1eeb nhi\u1ec1u file excel v\u00e0o 1 file kh\u00f4ng c\u1ea7n m\u1edf file<\/strong> r\u1ea5t nhanh ch\u00f3ng v\u00e0 ti\u1ec7n l\u1ee3i qua video sau \u0111\u00e2y:<\/p>\n<p style=\"text-align: center\"><iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/m5LjsRNGIMU\" width=\"560\" height=\"314\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<blockquote>\n<p style=\"text-align: left\">Ti\u0300m hi\u00ea\u0309u th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/excel-co-ban\">H\u01b0\u1edbng d\u1eabn h\u1ecdc excel c\u01a1 b\u1ea3n<\/a> \u0111\u00ea\u0301n n\u00e2ng cao<\/p>\n<\/blockquote>\n<p>\u0110o\u1ea1n code c\u00e1c b\u1ea1n c\u1ea7n thay \u0111\u1ed5i cho ph\u00f9 h\u1ee3p v\u1edbi d\u1eef li\u1ec7u l\u00e0 (xem ph\u1ea7n comment trong code)<\/p>\n<\/p>\n<div class=\"oembed-gist\">View the code on <a href=\"https:\/\/gist.github.com\/ndthanh\/c1d9a974228dd4c82f6deaa10f96724d\">Gist<\/a>.<\/div>\n<p><strong>Code cho h\u00e0m GetConnXLS()<\/strong><\/p>\n<p><strong>L\u01b0u \u00fd: <\/strong><\/p>\n<p>1. Trong b\u00e0i c\u00f3 s\u1eed d\u1ee5ng ki\u1ebfn th\u1ee9c v\u1ec1 <a href=\"https:\/\/hocexcel.online\/search\/kwd?q=vba201\" target=\"_blank\" rel=\"noopener noreferrer\">l\u1eadp tr\u00ecnh VBA n\u00e2ng cao<\/a>, k\u1ebft h\u1ee3p v\u1edbi <a href=\"https:\/\/hocexcel.online\/search\/kwd?q=sql\" target=\"_blank\" rel=\"noopener noreferrer\">ki\u1ebfn th\u1ee9c v\u1ec1 SQL<\/a>, n\u1ebfu b\u1ea1n c\u00f3 \u00fd \u0111\u1ecbnh \u0111\u1ea7u t\u01b0 th\u1eddi gian h\u1ecdc b\u00e0i b\u1ea3n nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y, h\u00e3y tham kh\u1ea3o tr\u00ean\u00a0<strong><a href=\"https:\/\/hocexcel.online\" target=\"_blank\" rel=\"noopener noreferrer\">H\u1ecdc Excel Online<\/a><\/strong><\/p>\n<p>2. H\u00e3y backup (t\u1ea1o 1 b\u1ea3n copy c\u1ee7a file b\u1ea1n \u0111ang l\u00e0m vi\u1ec7c c\u00f9ng v\u00e0 l\u01b0u \u1edf 1 n\u01a1i an to\u00e0n) tr\u01b0\u1edbc khi th\u1eed code copy t\u1eeb tr\u00ean m\u1ea1ng v\u1ec1, n\u1ebfu b\u1ea1n kh\u00f4ng bi\u1ebft m\u00ecnh \u0111ang l\u00e0m g\u00ec, h\u00e3y d\u1eebng l\u1ea1i tr\u01b0\u1edbc khi c\u00f3 ki\u1ebfn th\u1ee9c v\u1ec1 VBA t\u1ed1t h\u01a1n v\u00e0 bi\u1ebft tr\u01b0\u1edbc k\u1ebft qu\u1ea3 \u0111o\u1ea1n code m\u00ecnh copy v\u00e0o Excel.<\/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-339.gif\" title=\"vba101_92019-nho-339\"><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-744.gif\" title=\"ex101_92019-nho-744\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<div class=\"oembed-gist\">View the code on <a href=\"https:\/\/gist.github.com\/ndthanh\/c8277d80255238050de770806b8c9066\">Gist<\/a>.<\/div>\n<p>C\u00e1ch l\u00e0m n\u00e0y c\u00f3 1 \u0111i\u1ec3m c\u1ea7n l\u01b0u \u00fd l\u00e0: c\u00e1c file con \u0111\u01b0\u1ee3c t\u1ed5ng h\u1ee3p c\u1ea7n c\u00f3 c\u1ea5u tr\u00fac gi\u1ed1ng h\u1ec7t nhau (s\u1ed1 c\u1ed9t, t\u00ean c\u1ed9t v\u00e0 s\u1ed1 d\u00f2ng, v\u00f9ng d\u1eef li\u1ec7u). N\u1ebfu s\u1eed d\u1ee5ng c\u00e1ch n\u00e0y \u0111\u1ec3 t\u1ed5ng h\u1ee3p c\u00e1c file c\u00f3 c\u1ea5u tr\u00fac t\u00ean c\u1ed9t, s\u1ed1 l\u01b0\u1ee3ng c\u1ed9t gi\u1ed1ng nhau nh\u01b0ng kh\u00e1c nhau v\u1ec1 s\u1ed1 d\u00f2ng s\u1ebd d\u1eabn \u0111\u1ebfn vi\u1ec7c thi\u1ebfu d\u1eef li\u1ec7u trong file t\u1ed5ng h\u1ee3p.<\/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\/2znKKWu\">VBA101 \u2013 VBA c\u01a1 b\u1ea3n d\u00e0nh cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u<\/a> c\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. B\u1ea1n c\u00f3 th\u1ec3 ch\u1ee7 \u0111\u1ed9ng li\u00ean l\u1ea1c qua email: listen@HocExcel.Online<strong>\u00a0<\/strong>\u0111\u1ec3 bi\u1ebft th\u00eam chi ti\u1ebft v\u1ec1 nh\u1eefng \u01b0u \u0111\u00e3i hi\u1ec7n c\u00f3 cho b\u1ea1n n\u1ebfu b\u1ea1n l\u00e0 h\u1ecdc vi\u00ean m\u1edbi.<\/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-339.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":8220,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-8219","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\/8219","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=8219"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8219\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8220"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8219"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8219"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8219"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}