{"id":6724,"date":"2024-12-21T16:03:20","date_gmt":"2024-12-21T16:03:20","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-nhap-du-lieu-tu-trang-tinh-khac-trong-excel\/"},"modified":"2024-12-21T16:03:20","modified_gmt":"2024-12-21T16:03:20","slug":"cach-nhap-du-lieu-tu-trang-tinh-khac-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-nhap-du-lieu-tu-trang-tinh-khac-trong-excel\/","title":{"rendered":"C\u00e1ch nh\u1eadp d\u1eef li\u1ec7u t\u1eeb trang t\u00ednh kh\u00e1c trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\">Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n m\u1ed9t v\u00e0i m\u1eb9o \u0111\u1ec3 nh\u1eadp d\u1eef li\u1ec7 t\u1eeb trang t\u00ednh kh\u00e1c v\u00e0o trang t\u00ednh \u0111ang l\u00e0m vi\u1ec7c.<\/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-6766e6c73adf9\" 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\/cach-nhap-du-lieu-tu-trang-tinh-khac-trong-excel.html#Nhap_du_lieu_tu_trang_tinh_khac_bang_tinh_nang_Connections\" title=\"Nh\u1eadp d\u1eef li\u1ec7u t\u1eeb trang t\u00ednh kh\u00e1c b\u1eb1ng t\u00ednh n\u0103ng Connections\">Nh\u1eadp d\u1eef li\u1ec7u t\u1eeb trang t\u00ednh kh\u00e1c b\u1eb1ng t\u00ednh n\u0103ng Connections<\/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\/cach-nhap-du-lieu-tu-trang-tinh-khac-trong-excel.html#Nhap_du_lieu_tu_mot_trang_tinh_khac_bang_VBA_Code\" title=\"Nh\u1eadp d\u1eef li\u1ec7u t\u1eeb m\u1ed9t trang t\u00ednh kh\u00e1c b\u1eb1ng VBA Code\">Nh\u1eadp d\u1eef li\u1ec7u t\u1eeb m\u1ed9t trang t\u00ednh kh\u00e1c b\u1eb1ng VBA Code<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: left\"><span class=\"ez-toc-section\" id=\"Nhap_du_lieu_tu_trang_tinh_khac_bang_tinh_nang_Connections\"><\/span><strong>Nh\u1eadp d\u1eef li\u1ec7u t\u1eeb trang t\u00ednh kh\u00e1c b\u1eb1ng t\u00ednh n\u0103ng Connections<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n th\u00e2n thu\u1ed9c v\u1edbi t\u00ednh n\u0103ng\u00a0<em><strong>Connections<\/strong><\/em> trong Excel, b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadp d\u1eef li\u1ec7u t\u1eeb trang t\u00ednh kh\u00e1c sang trang t\u00ednh \u0111ang l\u00e0m vi\u1ec7c, v\u00e0 d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c nh\u1eadp s\u1ebd \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt t\u1ef1 \u0111\u1ed9ng c\u00f9ng v\u1edbi d\u1eef li\u1ec7u g\u1ed1c.<\/p>\n<p style=\"text-align: justify\">1. Nh\u1ea5p v\u00e0o <em><strong>Data &gt; Connections<\/strong><\/em>.<\/p>\n<p style=\"text-align: center\"><img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/doc-import-data-to-worksheet-1.jpg\" alt=\"doc-import-data-to-worksheet-1\" title=\"doc-import-data-to-worksheet-1\"><\/p>\n<p style=\"text-align: justify\">2. Trong h\u1ed9p tho\u1ea1i <em><strong>Workbook Connections<\/strong><\/em>, b\u1ea5m n\u00fat <em><strong>Add<\/strong><\/em>. H\u1ed9p tho\u1ea1i <em><strong>Existing Connections\u00a0<\/strong><\/em>hi\u1ec7n l\u00ean, nh\u1ea5p v\u00e0o n\u00fat <em><strong>Browse for More<\/strong><\/em>.<\/p>\n<p style=\"text-align: center\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7266\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/untitled-36.png\" width=\"575\" height=\"457\" title=\"untitled-36\"><\/p>\n<p style=\"text-align: center\"><img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/doc-import-data-to-worksheet-3.png\" alt=\"doc-import-data-to-worksheet-3\" title=\"doc-import-data-to-worksheet-3\"><\/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-265.gif\" title=\"vba101_92019-nho-265\"><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-604.gif\" title=\"ex101_92019-nho-604\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\">3. Sau \u0111\u00f3 ch\u1ecdn b\u1ea3ng t\u00ednh b\u1ea1n mu\u1ed1n xu\u1ea5t d\u1eef li\u1ec7u c\u1ee7a n\u00f3 sang trang t\u00ednh hi\u1ec7n t\u1ea1i.<\/p>\n<p style=\"text-align: center\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7268\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/doc-import-data-to-worksheet-4.png\" width=\"600\" height=\"402\" title=\"doc-import-data-to-worksheet-4\"><\/p>\n<p style=\"text-align: justify\">4. Sau khi ch\u1ecdn b\u1ea3ng t\u00ednh, nh\u1ea5p n\u00fat\u00a0<em><strong>Open<\/strong><\/em>, ch\u1ecdn m\u1ed9t trang t\u00ednh b\u1ea1n mu\u1ed1n s\u1eed d\u1ee5ng.<\/p>\n<p style=\"text-align: center\"><img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/doc-import-data-to-worksheet-5.png\" alt=\"doc-import-data-to-worksheet-1\" title=\"doc-import-data-to-worksheet-5\"><\/p>\n<p style=\"text-align: justify\">5. Nh\u1ea5p OK, n\u00f3 s\u1ebd tr\u1edf l\u1ea1i h\u1ed9p tho\u1ea1i <em><strong>Workbook Connections<\/strong><\/em>, v\u00e0 b\u1ea3ng t\u00ednh \u0111\u01b0\u1ee3c ch\u1ecdn s\u1ebd th\u00eam v\u00e0o h\u1ed9p danh s\u00e1ch, \u0111\u00f3ng h\u1ed9p tho\u1ea1i.<\/p>\n<p style=\"text-align: justify\">6. Nh\u1ea5p v\u00e0o <em><strong>Data &gt; Existing Connections<\/strong><\/em>.<\/p>\n<p style=\"text-align: center\"><img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/doc-import-data-to-worksheet-6.png\" alt=\"doc-import-data-to-worksheet-1\" title=\"doc-import-data-to-worksheet-6\"><\/p>\n<p style=\"text-align: justify\">7. Trong h\u1ed9p tho\u1ea1i\u00a0<em><strong>Existing Connections<\/strong><\/em>, ch\u1ecdn b\u1ea3ng t\u00ednh v\u1eeba \u0111\u01b0\u1ee3c th\u00eam, nh\u1ea5p n\u00fat\u00a0<em><strong>Open<\/strong><\/em>.<\/p>\n<p style=\"text-align: center\"><img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/doc-import-data-to-worksheet-7.png\" alt=\"doc-import-data-to-worksheet-1\" title=\"doc-import-data-to-worksheet-7\"><\/p>\n<p style=\"text-align: justify\">8. H\u1ed9p tho\u1ea1i <em><strong>Import Data<\/strong><\/em>\u00a0hi\u1ec7n ra, ch\u1ecdn m\u1ed9t t\u00f9y ch\u1ecdn b\u1ea1n th\u00edch t\u1eeb <em><strong>Select how you want to view this data in your workbook<\/strong><\/em>, sau \u0111\u00f3 ch\u1ecdn m\u1ed9t v\u00f9ng d\u1eef li\u1ec7u trong trang t\u00ednh c\u00f3 s\u1eb5n ho\u1eb7c m\u1ed9t trang t\u00ednh m\u1edbi \u0111\u1ec3 nh\u1eadp d\u1eef li\u1ec7u.<\/p>\n<p style=\"text-align: center\"><img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/doc-import-data-to-worksheet-8.png\" alt=\"doc-import-data-to-worksheet-1\" title=\"doc-import-data-to-worksheet-8\"><\/p>\n<p style=\"text-align: justify\">9. Sau \u0111\u00f3 nh\u1ea5p OK, d\u1eef li\u1ec7u t\u1eeb m\u1ed9t trang t\u00ednh kh\u00e1c v\u1eeba \u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o trang t\u00ednh b\u1ea1n ch\u1ecdn.<\/p>\n<p style=\"text-align: center\"><img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/doc-import-data-to-worksheet-9.png\" alt=\"doc-import-data-to-worksheet-1\" title=\"doc-import-data-to-worksheet-9\"><\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd.<\/strong><\/p>\n<p style=\"text-align: justify\">1. S\u1eed d\u1ee5ng ph\u01b0\u01a1ng ph\u00e1p n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadp d\u1eef li\u1ec7u v\u1edbi d\u1ea1ng b\u1ea3ng, PivotTable Report, PivotTableChart.<\/p>\n<p style=\"text-align: justify\">2. B\u1ea3ng t\u00ednh \u0111\u01b0\u1ee3c k\u1ebft n\u1ed1i v\u1edbi d\u1eef li\u1ec7u ngo\u00e0i, n\u1ebfu b\u1ea1n mu\u1ed1n c\u1eadp nh\u1eadt phi\u00ean b\u1ea3n g\u1ea7n nh\u1ea5t cho b\u1ea3ng t\u00ednh, v\u00e0o <em><strong>Data &gt; Refresh All<\/strong><\/em>\u00a0\u0111\u1ec3 c\u1eadp nh\u1eadt d\u1eef li\u1ec7u.<\/p>\n<p style=\"text-align: center\">\n<h2 style=\"text-align: left\"><span class=\"ez-toc-section\" id=\"Nhap_du_lieu_tu_mot_trang_tinh_khac_bang_VBA_Code\"><\/span><strong>Nh\u1eadp d\u1eef li\u1ec7u t\u1eeb m\u1ed9t trang t\u00ednh kh\u00e1c b\u1eb1ng <a href=\"http:\/\/blog.ezworkapp.com\/bat-dau-voi-excel-macros-va-lap-trinh-vba.html\" target=\"_blank\" rel=\"noopener noreferrer\">VBA Code<\/a><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">1. Nh\u1ea5n gi\u1eef ph\u00edm\u00a0<em><strong>Alt + F11<\/strong><\/em>, c\u1eeda s\u1ed5 <em><strong>Microsoft Visual Basic for Applications\u00a0<\/strong><\/em>m\u1edf ra.<\/p>\n<p style=\"text-align: justify\">2. Nh\u1ea5p <em><strong>Insert &gt; Module<\/strong><\/em>, d\u00e1n \u0111o\u1ea1n m\u00e3 sau v\u00e0o <em><strong>Module Window<\/strong><\/em>.<\/p>\n<div class=\"line number1 index0 alt2\"><code class=\"vb keyword\">Sub<\/code> <code class=\"vb plain\">ImportDatafromotherworksheet()<\/code><\/div>\n<div class=\"line number2 index1 alt1\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb keyword\">Dim<\/code> <code class=\"vb plain\">wkbCrntWorkBook <\/code><code class=\"vb keyword\">As<\/code> <code class=\"vb plain\">Workbook<\/code><\/div>\n<div class=\"line number3 index2 alt2\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb keyword\">Dim<\/code> <code class=\"vb plain\">wkbSourceBook <\/code><code class=\"vb keyword\">As<\/code> <code class=\"vb plain\">Workbook<\/code><\/div>\n<div class=\"line number4 index3 alt1\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb keyword\">Dim<\/code> <code class=\"vb plain\">rngSourceRange <\/code><code class=\"vb keyword\">As<\/code> <code class=\"vb plain\">Range<\/code><\/div>\n<div class=\"line number5 index4 alt2\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb keyword\">Dim<\/code> <code class=\"vb plain\">rngDestination <\/code><code class=\"vb keyword\">As<\/code> <code class=\"vb plain\">Range<\/code><\/div>\n<div class=\"line number6 index5 alt1\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb keyword\">Set<\/code> <code class=\"vb plain\">wkbCrntWorkBook = ActiveWorkbook<\/code><\/div>\n<div class=\"line number7 index6 alt2\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb keyword\">With<\/code> <code class=\"vb plain\">Application.FileDialog(msoFileDialogOpen)<\/code><\/div>\n<div class=\"line number8 index7 alt1\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb plain\">.Filters.Clear<\/code><\/div>\n<div class=\"line number9 index8 alt2\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb plain\">.Filters.Add <\/code><code class=\"vb string\">\"Excel 2007-13\"<\/code><code class=\"vb plain\">, <\/code><code class=\"vb string\">\"*.xlsx; *.xlsm; *.xlsa\"<\/code><\/div>\n<div class=\"line number10 index9 alt1\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb plain\">.AllowMultiSelect = <\/code><code class=\"vb keyword\">False<\/code><\/div>\n<div class=\"line number11 index10 alt2\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb plain\">.Show<\/code><\/div>\n<div class=\"line number12 index11 alt1\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb keyword\">If<\/code> <code class=\"vb plain\">.SelectedItems.Count &gt; 0 <\/code><code class=\"vb keyword\">Then<\/code><\/div>\n<div class=\"line number13 index12 alt2\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb plain\">Workbooks.Open .SelectedItems(1)<\/code><\/div>\n<div class=\"line number14 index13 alt1\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb keyword\">Set<\/code> <code class=\"vb plain\">wkbSourceBook = ActiveWorkbook<\/code><\/div>\n<div class=\"line number15 index14 alt2\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb keyword\">Set<\/code> <code class=\"vb plain\">rngSourceRange = Application.InputBox(prompt:=<\/code><code class=\"vb string\">\"Select source range\"<\/code><code class=\"vb plain\">, Title:=<\/code><code class=\"vb string\">\"Source Range\"<\/code><code class=\"vb plain\">, <\/code><code class=\"vb keyword\">Default<\/code><code class=\"vb plain\">:=<\/code><code class=\"vb string\">\"A1\"<\/code><code class=\"vb plain\">, Type:=8)<\/code><\/div>\n<div class=\"line number16 index15 alt1\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb plain\">wkbCrntWorkBook.Activate<\/code><\/div>\n<div class=\"line number17 index16 alt2\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb keyword\">Set<\/code> <code class=\"vb plain\">rngDestination = Application.InputBox(prompt:=<\/code><code class=\"vb string\">\"Select destination cell\"<\/code><code class=\"vb plain\">, Title:=<\/code><code class=\"vb string\">\"Select Destination\"<\/code><code class=\"vb plain\">, <\/code><code class=\"vb keyword\">Default<\/code><code class=\"vb plain\">:=<\/code><code class=\"vb string\">\"A1\"<\/code><code class=\"vb plain\">, Type:=8)<\/code><\/div>\n<div class=\"line number18 index17 alt1\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb plain\">rngSourceRange.Copy rngDestination<\/code><\/div>\n<div class=\"line number19 index18 alt2\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb plain\">rngDestination.CurrentRegion.EntireColumn.AutoFit<\/code><\/div>\n<div class=\"line number20 index19 alt1\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb plain\">wkbSourceBook.Close <\/code><code class=\"vb keyword\">False<\/code><\/div>\n<div class=\"line number21 index20 alt2\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb keyword\">End<\/code> <code class=\"vb keyword\">If<\/code><\/div>\n<div class=\"line number22 index21 alt1\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb keyword\">End<\/code> <code class=\"vb keyword\">With<\/code><\/div>\n<div class=\"line number23 index22 alt2\"><code class=\"vb keyword\">End<\/code> <code class=\"vb keyword\">Sub<\/code><\/div>\n<div class=\"line number23 index22 alt2\"><\/div>\n<div class=\"line number23 index22 alt2\">3. Nh\u1ea5n\u00a0<em><strong>F5\u00a0<\/strong><\/em>\u0111\u1ec3 ch\u1ea1y m\u00e3, m\u1ed9t h\u1ed9p tho\u1ea1i hi\u1ec7n ra nh\u1eafc nh\u1edf b\u1ea1n ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n ch\u00e8n d\u1eef li\u1ec7u c\u1ee7a n\u00f3 v\u00e0o trang t\u00ednh hi\u1ec7n t\u1ea1i.<\/div>\n<div class=\"line number23 index22 alt2\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7274\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/doc-import-data-to-worksheet-11.png\" width=\"600\" height=\"416\" title=\"doc-import-data-to-worksheet-11\"><\/div>\n<div class=\"line number23 index22 alt2\" style=\"text-align: justify\">4. Sau khi ch\u1ecdn b\u1ea3ng t\u00ednh, nh\u1ea5n n\u00fat\u00a0<em><strong>Open<\/strong><\/em>, ch\u1ecdn m\u1ed9t trang t\u00ednh ho\u1eb7c m\u1ed9t v\u00f9ng d\u1eef li\u1ec7u trong b\u1ea3ng t\u00ednh b\u1ea1n c\u1ea7n xu\u1ea5t.<\/div>\n<div class=\"line number23 index22 alt2\" style=\"text-align: center\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7275\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/doc-import-data-to-worksheet-12.png\" width=\"595\" height=\"355\" title=\"doc-import-data-to-worksheet-12\"><\/div>\n<div class=\"line number23 index22 alt2\" style=\"text-align: justify\"><\/div>\n<div class=\"line number23 index22 alt2\" style=\"text-align: justify\">5. Nh\u1ea5n OK, ch\u1ecdn m\u1ed9t \u00f4 t\u00ednh \u0111\u1ec3 \u0111\u1eb7t d\u1eef li\u1ec7u v\u00e0o trang t\u00ednh hi\u1ec7n t\u1ea1i.<\/div>\n<div class=\"line number23 index22 alt2\" style=\"text-align: center\"><img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/doc-import-data-to-worksheet-13.png\" alt=\"doc-import-data-to-worksheet-1\" title=\"doc-import-data-to-worksheet-13\"><\/div>\n<div class=\"line number23 index22 alt2\" style=\"text-align: justify\">6. Nh\u1ea5n OK, d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c ch\u1ecdn v\u1eeba \u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o trang t\u00ednh hi\u1ec7n t\u1ea1i.<\/div>\n<div class=\"line number23 index22 alt2\" style=\"text-align: justify\"><strong>Ch\u00fa \u00fd.\u00a0<\/strong>V\u1edbi ph\u01b0\u01a1ng ph\u00e1p n\u00e0y, d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c nh\u1eadp s\u1ebd kh\u00f4ng \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt c\u00f9ng v\u1edbi b\u1ea3n g\u1ed1c.<\/div>\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-265.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":6725,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-6724","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\/6724","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=6724"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6724\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/6725"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=6724"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=6724"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=6724"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}