{"id":4983,"date":"2024-12-08T19:43:40","date_gmt":"2024-12-08T19:43:40","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/08\/chon-nhanh-gia-ban-cua-hang-hoa-dua-vao-lich-su-giao-dich-bang-vba\/"},"modified":"2024-12-08T19:43:40","modified_gmt":"2024-12-08T19:43:40","slug":"chon-nhanh-gia-ban-cua-hang-hoa-dua-vao-lich-su-giao-dich-bang-vba","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/08\/chon-nhanh-gia-ban-cua-hang-hoa-dua-vao-lich-su-giao-dich-bang-vba\/","title":{"rendered":"Ch\u1ecdn nhanh gi\u00e1 b\u00e1n c\u1ee7a h\u00e0ng h\u00f3a d\u1ef1a v\u00e0o l\u1ecbch s\u1eed giao d\u1ecbch b\u1eb1ng VBA"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-dQf5b79p#1\">\n<p><span style=\"font-size: 24pt\"><strong>Ch\u00e0o b\u1ea1n !<\/strong><\/span><\/p>\n<p>M\u1ed9t m\u1eb7t h\u00e0ng c\u00f3 th\u1ec3 c\u00f3 nhi\u1ec1u \u0111\u01a1n gi\u00e1 kh\u00e1c nhau, g\u00e2y n\u00ean b\u1ea5t ti\u1ec7n r\u1ea5t l\u1edbn trong vi\u1ec7c nh\u1eadp li\u1ec7u.<\/p>\n<p><em>V\u00ed d\u1ee5 nh\u01b0 sau :<\/em><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-16953\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/chon-nhanh-gia-ban-cua-hang-hoa-dua-vao-lich-su-giao-dich-bang-vba1-1.jpg\" width=\"1305\" height=\"727\" title=\"chon-nhanh-gia-ban-cua-hang-hoa-dua-vao-lich-su-giao-dich-bang-vba1-1\"><\/p>\n<p>\u00a0<\/p>\n<p>Nh\u01b0 v\u00ed d\u1ee5 tr\u00ean m\u1eb7t h\u00e0ng A c\u00f3 t\u1edbi 4 gi\u00e1 b\u00e1n trong l\u1ecbch s\u1eed giao d\u1ecbch \u0111\u00e3 \u0111\u01b0\u1ee3c ghi nh\u1eadn.V\u1ea5n \u0111\u1ec1 l\u00e0 khi ch\u00fang ta nh\u1eadp li\u1ec7u c\u0169ng m\u1eb7t h\u00e0ng A \u0111\u00f3 ph\u1ea7n \u0111\u01a1n gi\u00e1 cho ph\u00e9p ch\u00fang ta t\u00f9y ch\u1ecdn gi\u00e1 b\u00e1n d\u1ef1a v\u00e0o l\u1ecbch s\u1eed giao d\u1ecbch tr\u01b0\u1edbc \u0111\u00f3 m\u00e0 kh\u00f4ng ph\u1ea3i lo \u0111\u1ebfn chuy\u1ec7n g\u00f5 sai n\u1eefa.\u00a0V\u00ed d\u1ee5 nh\u01b0 h\u00ecnh d\u01b0\u1edbi :<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-16949\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/chon-nhanh-gia-ban-cua-hang-hoa-dua-vao-lich-su-giao-dich-bang-vba3.jpg\" width=\"1035\" height=\"114\" title=\"chon-nhanh-gia-ban-cua-hang-hoa-dua-vao-lich-su-giao-dich-bang-vba3\"><\/p>\n<p><em>\u0110\u1ec3 \u0111\u00e1p \u1ee9ng y\u00eau c\u1ea7u c\u1ee7a b\u00e0i to\u00e1n tr\u00ean t\u00f4i d\u00f9ng VBA nh\u01b0 sau\u00a0 :<\/em><\/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-161.gif\" title=\"vba101_92019-nho-161\"><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-414.gif\" title=\"ex101_92019-nho-414\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<div class=\"oembed-gist\">View the code on <a href=\"https:\/\/gist.github.com\/TGDUY\/1a056593146157055c7718dfde8ed68d\">Gist<\/a>.<\/div>\n<p><em>C\u00e1ch\u00a0ch\u00fang ta nh\u1eadp li\u1ec7u s\u1ebd\u00a0\u00a0nh\u01b0 sau :\u00a0<\/em><\/p>\n<ul>\n<li>B\u1ea1n nh\u1eadp m\u00e3 h\u00e0ng h\u00f3a sau \u0111\u00f3 ch\u1ecdn \u00f4 \u0111\u01a1n gi\u00e1 nh\u1ea5n t\u1ed5 h\u1ee3p ph\u00edm <strong>[Ctr Q]<\/strong><\/li>\n<\/ul>\n<p>sau \u0111\u00f3 list ch\u1ecdn \u0111\u01a1n gi\u00e1 c\u1ee7a m\u1eb7t h\u00e0ng 1 \u0111\u00e3 t\u1ef1 \u0111\u1ed9ng \u0111\u01b0\u1ee3c xu\u1ea5t hi\u1ec7n \u0111\u1ec3 cho b\u1ea1n l\u1ef1a ch\u1ecdn.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-16915\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/chon-nhanh-gia-ban-cua-hang-hoa-dua-vao-lich-su-giao-dich-bang-vba2.jpg\" width=\"1200\" height=\"800\" title=\"chon-nhanh-gia-ban-cua-hang-hoa-dua-vao-lich-su-giao-dich-bang-vba2\"><\/p>\n<p><em>R\u1ea5t ti\u1ec7n \u0111\u00fang kh\u00f4ng n\u00e0o? N\u1ebfu v\u1eabn ch\u01b0a r\u00f5 b\u1ea1n c\u00f3 th\u1ec3 xem video d\u01b0\u1edbi \u0111\u00e2y nh\u00e9.<\/em><\/p>\n<iframe loading=\"lazy\" title=\"Ch\u1ecdn nhanh gi\u00e1 b\u00e1n c\u1ee7a h\u00e0ng h\u00f3a d\u1ef1a v\u00e0o l\u1ecbch s\u1eed giao d\u1ecbch b\u1eb1ng VBA\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/gnkxjJ75sw8?feature=oembed\" frameborder allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe>\n<p>B\u1ea1n download file \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong video t\u1ea1i \u0111\u00e2y :<\/p>\n<p><span style=\"color: #0000ff\"><em>\u00a0 \u00a0 \u00a0 \u00a0<strong>Th\u1eed t\u01b0\u1ee3ng xem n\u1ebfu d\u1eef li\u1ec7u h\u00e0ng h\u00f3a c\u1ee7a ch\u00fang ta c\u00f3 \u0111\u1ebfn h\u00e0ng\u00a0v\u1ea1n d\u00f2ng v\u1edbi h\u00e0ng ngh\u00ecn m\u1eb7t h\u00e0ng. B\u1ea1n s\u1ebd th\u1ea5y r\u1eb1ng \u0111\u1ec3 ch\u1ecdn gi\u00e1 b\u00e1n cho t\u1eebng m\u1eb7t h\u00e0ng s\u1ebd r\u1ea5t v\u1ea5t v\u1ea3.\u00a0Tuy nhi\u00ean,\u00a0n\u1ebfu b\u1ea1n t\u1eadn d\u1ee5ng \u0111\u01b0\u1ee3c s\u1ee9c m\u1ea1nh VBA b\u1ea1n s\u1ebd ti\u1ebft ki\u1ec7m \u0111\u01b0\u1ee3c r\u1ea5t nhi\u1ec1u th\u1eddi gian v\u00e0 s\u1ee9c l\u1ef1c.\u00a0\u00a0N\u1ebfu b\u1ea1n mu\u1ed1n t\u00ecm hi\u1ec3u v\u1ec1 VBA v\u00e0 h\u1ecdc c\u00e1ch l\u00e0m ch\u1ee7 n\u00f3 th\u00ec li\u00ean h\u1ec7 v\u1edbi ch\u00fang t\u00f4i b\u1eb1ng c\u00e1ch click v\u00e0o h\u00ecnh \u1ea3nh ph\u00eda d\u01b0\u1edbi nh\u00e9 !<\/strong><\/em><\/span><\/p>\n<p>Ch\u00fac b\u1ea1n h\u1ecdc t\u1ed1t c\u00f9ng\u00a0<a href=\"https:\/\/hocexcel.online\/\">Hocexcel.online<\/a><\/p>\n<p>\u00a0<\/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-161.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":4984,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-4983","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\/4983","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=4983"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4983\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/4984"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=4983"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=4983"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=4983"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}