{"id":6964,"date":"2024-12-21T16:37:23","date_gmt":"2024-12-21T16:37:23","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-tham-chieu-cung-mot-o-tu-nhieu-trang-tinh-trong-excel\/"},"modified":"2024-12-21T16:37:23","modified_gmt":"2024-12-21T16:37:23","slug":"cach-tham-chieu-cung-mot-o-tu-nhieu-trang-tinh-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-tham-chieu-cung-mot-o-tu-nhieu-trang-tinh-trong-excel\/","title":{"rendered":"C\u00e1ch tham chi\u1ebfu c\u00f9ng m\u1ed9t \u00f4 t\u1eeb nhi\u1ec1u trang t\u00ednh trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-dQf5b79p#1\">\n<p>Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1ch tham chi\u1ebfu c\u00f9ng m\u1ed9t \u0111\u1ecba ch\u1ec9 \u00f4 t\u1eeb nhi\u1ec1u trang t\u00ednh.<\/p>\n<p>Ch\u00fang ta x\u00e9t v\u00ed d\u1ee5 sau. Ta c\u00f3 m\u1ed9t b\u1ea3ng t\u00ednh v\u1edbi 5 trang t\u00ednh, 4 trong 5 trang t\u00ednh \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng gi\u1ed1ng nhau, v\u1edbi t\u1ed5ng \u0111\u01a1n \u0111\u1eb7t h\u00e0ng \u1edf \u00f4 B6. B\u00e2y gi\u1edd t\u00f4i mu\u1ed1n tham chi\u1ebfu \u00f4 B6 t\u1eeb 4 trang t\u00ednh n\u00e0y v\u00e0 \u0111i\u1ec1n ch\u00fang v\u00e0o trang t\u00ednh t\u1ed5ng h\u1ee3p.<\/p>\n<h2><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/06\/New-Bitmap-Image-2.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7249\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2.bmp\" width=\"600\" height=\"202\" title=\"new-bitmap-image-2\"><\/a><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/06\/1.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7251\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1.bmp\" width=\"537\" height=\"341\" title=\"1\"><\/a><\/h2>\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-6766eec30b417\" 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-tham-chieu-cung-mot-o-tu-nhieu-trang-tinh-trong-excel.html#Tham_chieu_cung_mot_o_tu_nhieu_trang_tinh_voi_chuc_nang_Copy_Paste_tung_cai_mot\" title=\"Tham chi\u1ebfu c\u00f9ng m\u1ed9t \u00f4 t\u1eeb nhi\u1ec1u trang t\u00ednh v\u1edbi ch\u1ee9c n\u0103ng Copy &amp; Paste t\u1eebng c\u00e1i m\u1ed9t\">Tham chi\u1ebfu c\u00f9ng m\u1ed9t \u00f4 t\u1eeb nhi\u1ec1u trang t\u00ednh v\u1edbi ch\u1ee9c n\u0103ng Copy &amp; Paste t\u1eebng c\u00e1i m\u1ed9t<\/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-tham-chieu-cung-mot-o-tu-nhieu-trang-tinh-trong-excel.html#Tham_chieu_cung_mot_o_tu_nhieu_trang_tinh_voi_ma_VBA\" title=\"Tham chi\u1ebfu c\u00f9ng m\u1ed9t \u00f4 t\u1eeb nhi\u1ec1u trang t\u00ednh v\u1edbi m\u00e3 VBA\">Tham chi\u1ebfu c\u00f9ng m\u1ed9t \u00f4 t\u1eeb nhi\u1ec1u trang t\u00ednh v\u1edbi m\u00e3 VBA<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Tham_chieu_cung_mot_o_tu_nhieu_trang_tinh_voi_chuc_nang_Copy_Paste_tung_cai_mot\"><\/span><strong>Tham chi\u1ebfu c\u00f9ng m\u1ed9t \u00f4 t\u1eeb nhi\u1ec1u trang t\u00ednh v\u1edbi ch\u1ee9c n\u0103ng Copy &amp; Paste t\u1eebng c\u00e1i m\u1ed9t<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Ch\u00fang ta c\u00f3 th\u1ec3 d\u00f9ng ch\u1ee9c n\u0103ng Copy v\u00e0 Paste.<\/p>\n<p>1. Ch\u1ecdn B6 trong trang Monday, nh\u1ea5n Ctrl+C<\/p>\n<p>2. \u0110\u1ebfn trang t\u1ed5ng h\u1ee3p, t\u1ea1i c\u1ed9t Total, d\u00f2ng Monday, nh\u1ea5p ph\u1ea3i ch\u1ecdn <strong>Paste Special<\/strong>.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/06\/2.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7252\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2.bmp\" width=\"600\" height=\"390\" title=\"2\"><\/a>3. Trong h\u1ed9p tho\u1ea1i <strong>Paste Special<\/strong>, nh\u1ea5n <strong>Paste Link.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/doc-fill-refs4.png\" alt=\"doc-fill-refs4\" width=\"381\" height=\"338\" title=\"doc-fill-refs4\"><\/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-279.gif\" title=\"vba101_92019-nho-279\"><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-628.gif\" title=\"ex101_92019-nho-628\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>4. K\u1ebft qu\u1ea3 \u0111\u00e3 \u0111\u01b0\u1ee3c sao ch\u00e9p v\u00e0 li\u00ean k\u1ebft \u0111\u1ebfn d\u1eef li\u1ec7u ngu\u1ed3n<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/doc-fill-refs5.png\" alt=\"doc-fill-refs5\" width=\"386\" height=\"198\" title=\"doc-fill-refs5\"><\/p>\n<p>5. L\u1eb7p l\u1ea1i nh\u1eefng b\u01b0\u1edbc tr\u00ean cho c\u00e1c gi\u00e1 tr\u1ecb t\u1eeb c\u00e1c trang t\u00ednh kh\u00e1c.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Tham_chieu_cung_mot_o_tu_nhieu_trang_tinh_voi_ma_VBA\"><\/span><strong>Tham chi\u1ebfu c\u00f9ng m\u1ed9t \u00f4 t\u1eeb nhi\u1ec1u trang t\u00ednh v\u1edbi m\u00e3 VBA<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>N\u1ebfu c\u00f3 h\u00e0ng ch\u1ee5c trang t\u00ednh, ch\u1ee9c n\u0103ng Copy &amp; Paste s\u1ebd t\u1ed1n th\u1eddi gian. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, <a href=\"http:\/\/blog.ezworkapp.com\/bat-dau-voi-excel-macros-va-lap-trinh-vba.html\" target=\"_blank\">m\u00e3 VBA<\/a> sau c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n.<\/p>\n<p>1. T\u1ea1i trang t\u1ed5ng h\u1ee3p, ch\u1ecdn B6 l\u00e0 \u00f4 b\u1ea1n mu\u1ed1n l\u1ea5y d\u1eef li\u1ec7u t\u1eeb trang kh\u00e1c.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/doc-fill-refs6.png\" alt=\"doc-fill-refs6\" width=\"484\" height=\"316\" title=\"doc-fill-refs6\"><\/p>\n<p>2. Nh\u1ea5n <strong>ALT+F11, <\/strong>m\u1edf c\u1eeda s\u1ed5 <strong>Microsoft Visual Basic for Applications<\/strong><\/p>\n<p>3. Nh\u1ea5n <strong>Insert<\/strong> &gt; <strong>Module<\/strong>, d\u00e1n \u0111o\u1ea1n m\u00e3 sau v\u00e0o c\u1eeda s\u1ed5 <strong>Module<\/strong><\/p>\n<\/p>\n<div class=\"oembed-gist\">View the code on <a href=\"https:\/\/gist.github.com\/ndthanh\/6d49058cbdd5b76813dd298d1e407eea\">Gist<\/a>.<\/div>\n<div class=\"container\">\n<div class=\"line number1 index0 alt2\"><\/div>\n<div class=\"line number21 index20 alt2\">4. Nh\u1ea5n F5 \u0111\u1ec3 ch\u1ea1y m\u00e3, t\u1ea5t c\u1ea3 gi\u00e1 tr\u1ecb trong \u00f4 B6 t\u1eeb c\u00e1 trang t\u00ednh kh\u00e1c s\u1ebd \u0111\u01b0\u1ee3c \u0111i\u1ec1n v\u00e0o trang t\u1ed5ng.<\/div>\n<div class=\"line number21 index20 alt2\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/doc-fill-refs7.png\" alt=\"doc-fill-refs7\" width=\"415\" height=\"244\" title=\"doc-fill-refs7\"><\/div>\n<div class=\"line number21 index20 alt2\"><strong>Ch\u00fa \u00fd: <\/strong>\u0110o\u1ea1n m\u00e3 VBA n\u00e0y kh\u1ea3 d\u1ee5ng khi b\u1ea1n nh\u1ea5n v\u00e0o \u00f4. V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n nh\u1ea5n \u00f4 A1 trong m\u1ed9t trang t\u00ednh c\u1ee5 th\u1ec3, t\u1ea5t c\u1ea3 c\u00e1c gi\u00e1 tr\u1ecb c\u1ee7a A1 t\u1eeb c\u00e1c trang t\u00ednh kh\u00e1c s\u1ebd \u0111\u01b0\u1ee3c \u0111i\u1ec1n v\u00e0o trang t\u00ednh.<\/div>\n<\/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-279.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":6965,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-6964","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\/6964","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=6964"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6964\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/6965"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=6964"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=6964"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=6964"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}