{"id":14077,"date":"2020-11-13T11:02:30","date_gmt":"2020-11-13T04:02:30","guid":{"rendered":"http:\/\/help.sme2021.misa.local\/?post_type=ht_kb&#038;p=14077"},"modified":"2025-11-03T08:38:05","modified_gmt":"2025-11-03T01:38:05","slug":"copy-du-lieu-tu-excel-vao-chung-tu","status":"publish","type":"ht_kb","link":"https:\/\/helpsme.misa.vn\/2026\/kb\/copy-du-lieu-tu-excel-vao-chung-tu\/","title":{"rendered":"Copy d\u1eef li\u1ec7u t\u1eeb excel v\u00e0o ch\u1ee9ng t\u1eeb"},"content":{"rendered":"<div class=\"su-accordion su-u-trim\">\n<div class=\"su-spoiler su-spoiler-style-default su-spoiler-icon-plus\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span><\/p>\n<h3><b>1. T\u1ed5ng quan<\/b><\/h3>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<b>M\u1ee5c \u0111\u00edch:<\/b> H\u01b0\u1edbng d\u1eabn c\u00e1ch copy tr\u1ef1c ti\u1ebfp t\u1eebng c\u1ed9t d\u1eef li\u1ec7u t\u1eeb Excel v\u00e0o giao di\u1ec7n nh\u1eadp li\u1ec7u tr\u00ean ph\u1ea7n m\u1ec1m, gi\u00fap nh\u1eadp li\u1ec7u nhanh ch\u00f3ng m\u00e0 kh\u00f4ng c\u1ea7n t\u1ea1o file nh\u1eadp kh\u1ea9u.<br \/>\n<b>N\u1ed9i dung:<\/b><\/p>\n<ul>\n<li>Gi\u1edbi thi\u1ec7u ch\u1ee9c n\u0103ng copy d\u1eef li\u1ec7u t\u1eeb Excel v\u00e0o ph\u1ea7n m\u1ec1m.<\/li>\n<li>Danh s\u00e1ch c\u00e1c ch\u1ee9ng t\u1eeb v\u00e0 ph\u00e2n h\u1ec7 h\u1ed7 tr\u1ee3 thao t\u00e1c n\u00e0y.<\/li>\n<li>H\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch th\u1ef1c hi\u1ec7n v\u00e0 c\u00e1c l\u01b0u \u00fd khi s\u1eed d\u1ee5ng.<\/li>\n<\/ul>\n<p><b>Ph\u1ea1m vi \u00e1p d\u1ee5ng:<\/b> K\u1ebf to\u00e1n, Th\u1ee7 kho, Nh\u00e2n vi\u00ean nh\u1eadp li\u1ec7u, Qu\u1ea3n l\u00fd kho, Qu\u1ea3n l\u00fd mua h\u00e0ng, Qu\u1ea3n l\u00fd b\u00e1n h\u00e0ng<\/p>\n<p><b>Danh s\u00e1ch ch\u1ee9ng t\u1eeb h\u1ed7 tr\u1ee3 copy t\u1eeb Excel<\/b><\/p>\n<table style=\"border-collapse: collapse; width: 100%;\">\n<tbody>\n<tr>\n<td style=\"text-align: center;\"><b>Ph\u00e2n h\u1ec7 Mua h\u00e0ng<\/b><\/td>\n<td style=\"text-align: center;\"><b>Ph\u00e2n h\u1ec7 B\u00e1n h\u00e0ng<\/b><\/td>\n<td style=\"text-align: center;\"><b>Ph\u00e2n h\u1ec7 ng\u00e2n s\u00e1ch<\/b><\/td>\n<td style=\"text-align: center;\"><b>Ph\u00e2n h\u1ec7 kho<\/b><\/td>\n<\/tr>\n<tr>\n<td>1. \u0110\u01a1n mua h\u00e0ng<br \/>\n2. H\u1ee3p \u0111\u1ed3ng mua h\u00e0ng<br \/>\n3. Ch\u1ee9ng t\u1eeb mua h\u00e0ng ho\u00e1<br \/>\n4. Ch\u1ee9ng t\u1eeb mua h\u00e0ng ho\u00e1 nhi\u1ec1u ho\u00e1 \u0111\u01a1n<br \/>\n5. Ch\u1ee9ng t\u1eeb mua d\u1ecbch v\u1ee5<br \/>\n6. Ch\u1ee9ng t\u1eeb tr\u1ea3 l\u1ea1i h\u00e0ng mua<br \/>\n7. Ch\u1ee9ng t\u1eeb gi\u1ea3m gi\u00e1 h\u00e0ng mua<\/td>\n<td>1. B\u00e1o gi\u00e1<br \/>\n2. \u0110\u01a1n \u0111\u1eb7t h\u00e0ng<br \/>\n3. Ch\u1ee9ng t\u1eeb b\u00e1n h\u00e0ng<br \/>\n4. Ho\u00e1 \u0111\u01a1n &amp; h\u00f3a \u0111\u01a1n \u0111i\u1ec1u ch\u1ec9nh<br \/>\n5. Ch\u1ee9ng t\u1eeb gi\u1ea3m gi\u00e1 h\u00e0ng b\u00e1n<br \/>\n6. Ch\u1ee9ng t\u1eeb tr\u1ea3 l\u1ea1i h\u00e0ng b\u00e1n<\/td>\n<td>1. L\u1eadp d\u1ef1 to\u00e1n ng\u00e2n s\u00e1ch<\/td>\n<td>1. Phi\u1ebfu nh\u1eadp kho<br \/>\n2. Phi\u1ebfu xu\u1ea5t kho<br \/>\n3. Phi\u1ebfu chuy\u1ec3n kho<br \/>\n4. L\u1ec7nh s\u1ea3n xu\u1ea5t<br \/>\n5. L\u1ec7nh l\u1eafp r\u00e1p, th\u00e1o d\u1ee1<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div><\/div>\n<div class=\"su-spoiler su-spoiler-style-default su-spoiler-icon-plus\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span><\/p>\n<h3><b>2. C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n<\/b><\/h3>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\nCh\u1ee9c n\u0103ng copy d\u1eef li\u1ec7u t\u1eeb Excel \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> T\u1ea1i giao di\u1ec7n file excel, th\u1ef1c hi\u1ec7n <strong>b\u00f4i \u0111en c\u00e1c d\u1eef li\u1ec7u c\u1ea7n copy<\/strong>, nh\u1ea5n chu\u1ed9t ph\u1ea3i, ch\u1ecdn<strong> Copy<\/strong>.<\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> Tr\u00ean giao di\u1ec7n nh\u1eadp li\u1ec7u ch\u1ee9ng t\u1eeb tr\u00ean ph\u1ea7n m\u1ec1m , nh\u1ea5n <strong>chu\u1ed9t ph\u1ea3i t\u1ea1i n\u1ed9i dung c\u1ed9t c\u1ea7n d\u00e1n d\u1eef li\u00eau<\/strong>\/ch\u1ecdn <strong>Sao ch\u00e9p nhi\u1ec1u d\u00f2ng excel v\u00e0o c\u1ed9t.<\/strong><\/p>\n<p>Xem video h\u01b0\u1edbng d\u1eabn thao t\u00e1c d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full\" src=\"https:\/\/helpsme.misa.vn\/2022\/wp-content\/uploads\/2020\/11\/copyexcel.gif\" alt=\"\" width=\"1420\" height=\"1000\" \/><\/p>\n<\/div><\/div>\n<div class=\"su-spoiler su-spoiler-style-default su-spoiler-icon-plus\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span><\/p>\n<h3><b>3. L\u01b0u \u00fd<\/b><\/h3>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<ul>\n<li>Ch\u1ec9 c\u00f3 th\u1ec3 copy \u0111\u01b0\u1ee3c t\u1eebng c\u1ed9t, kh\u00f4ng th\u1ec3 copy nhi\u1ec1u c\u1ed9t c\u00f9ng l\u00fac. C\u00e1c c\u1ed9t c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c ch\u1ee9c n\u0103ng copy t\u1eeb Excel bao g\u1ed3m: <b>M\u00e3 h\u00e0ng; T\u00ean h\u00e0ng; \u0110\u01a1n v\u1ecb t\u00ednh; \u0110\u01a1n gi\u00e1; S\u1ed1 l\u01b0\u1ee3ng; Ti\u1ec1n chi\u1ebft kh\u1ea5u; T\u1ef7 l\u1ec7 chi\u1ebft kh\u1ea5u; % thu\u1ebf su\u1ea5t GTGT, Tr\u01b0\u1eddng m\u1edf r\u1ed9ng.<\/b><\/li>\n<li>Sau khi copy c\u1ed9t <b>M\u00e3 h\u00e0ng<\/b> ho\u1eb7c c\u1ed9t <b>T\u00ean h\u00e0ng<\/b>, n\u1ebfu tr\u00f9ng v\u1edbi m\u1eb7t h\u00e0ng \u0111\u00e3 c\u00f3 trong danh m\u1ee5c, ch\u01b0\u01a1ng tr\u00ecnh s\u1ebd t\u1ef1 \u0111\u1ed9ng nh\u1eadn di\u1ec7n v\u00e0 \u0111i\u1ec1n c\u00e1c th\u00f4ng tin c\u00f2n l\u1ea1i nh\u01b0 T\u00ean h\u00e0ng\/M\u00e3 h\u00e0ng\/\u0110VT\/\u0110\u01a1n gi\u00e1&#8230;<\/li>\n<li>N\u1ebfu <b>M\u00e3 h\u00e0ng\/T\u00ean h\u00e0ng<\/b> ch\u01b0a c\u00f3 trong danh m\u1ee5c, K\u1ebf to\u00e1n ph\u1ea3i t\u1ef1 ch\u1ecdn l\u1ea1i m\u00e3 h\u00e0ng \u0111\u00e3 c\u00f3 ho\u1eb7c t\u1ea1o m\u1edbi m\u00e3 h\u00e0ng.<\/li>\n<li>N\u1ebfu g\u1eb7p l\u1ed7i \u0111\u1ecbnh d\u1ea1ng s\u1ed1 khi copy d\u1eef li\u1ec7u t\u1eeb Excel v\u00e0o c\u1ed9t ph\u1ea7n m\u1ec1m, tham kh\u1ea3o h\u01b0\u1edbng d\u1eabn kh\u1eafc ph\u1ee5c <a href=\"https:\/\/helpsme.misa.vn\/2026\/kb\/loi-dinh-dang-so-khi-sao-chep-nhieu-dong-excel-vao-cot-tren-giao-dien-lap-chung-tu\/\">T\u1ea1i \u0111\u00e2y<\/a>.<\/li>\n<\/ul>\n<\/div><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":133,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"_links_to":"","_links_to_target":"","footnotes":""},"ht-kb-category":[2566],"ht-kb-tag":[],"class_list":["post-14077","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-huong-dan-4__khac"],"_links":{"self":[{"href":"https:\/\/helpsme.misa.vn\/2026\/wp-json\/wp\/v2\/ht-kb\/14077","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/helpsme.misa.vn\/2026\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/helpsme.misa.vn\/2026\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/helpsme.misa.vn\/2026\/wp-json\/wp\/v2\/users\/133"}],"replies":[{"embeddable":true,"href":"https:\/\/helpsme.misa.vn\/2026\/wp-json\/wp\/v2\/comments?post=14077"}],"version-history":[{"count":5,"href":"https:\/\/helpsme.misa.vn\/2026\/wp-json\/wp\/v2\/ht-kb\/14077\/revisions"}],"predecessor-version":[{"id":50415,"href":"https:\/\/helpsme.misa.vn\/2026\/wp-json\/wp\/v2\/ht-kb\/14077\/revisions\/50415"}],"wp:attachment":[{"href":"https:\/\/helpsme.misa.vn\/2026\/wp-json\/wp\/v2\/media?parent=14077"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/helpsme.misa.vn\/2026\/wp-json\/wp\/v2\/ht-kb-category?post=14077"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/helpsme.misa.vn\/2026\/wp-json\/wp\/v2\/ht-kb-tag?post=14077"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}