Top doanh nghiệp đã đăng ký cho nhân viên

Bạn sẽ học được gì?

Hình thành tư duy lập trình VBA cơ bản giúp giải quyết các vấn đề tận gốc thông qua các bài tập thiết thực trong công việc.
Hiểu cặn kẽ các kiến thức căn bản.
Biết cách tự viết code, đọc hiểu code và sửa code VBA.
Thiết lập một tiện ích tự động xử lý số liệu.
Thay đổi menu Excel, tạo form nhập liệu bằng VBA theo ý muốn.
Viết được các mã lệnh Macro để tự động phân tích, nhập và xử lý số liệu.
Nắm được một số kỹ năng lập trình thông dụng: Phát hiện và xử lý lỗi, tạo Userform, sự kiện, in hàng loạt, thêm/sửa/xóa dữ liệu, nạp dữ liệu, trích xuất dữ liệu...
Ứng dụng nội dung khóa học VBA online vào một số công việc cụ thể trong quản lý nhân sự, kế toán, tài chính, quản lý dự án...

Khoá học này sẽ có:

Video

13h 17m giờ học

Article

3 bài viết chuyên môn

Material

24 tài liệu đính kèm

Exam questions

1 đề thi ghi nhớ kiến thức

Nội dung khoá học

18 Chương . 130 bài giảng . 13h 17m giờ học

1

CHƯƠNG MỞ ĐẦU

2

Tổng quan về VBA

5 bài học thử
3

Cách ghi và sử dụng Macro

3 bài học thử
4

Tìm hiểu về Module trong VBA

1 bài học thử
5

Kỹ thuật viết code trong VBA

2 bài học thử
6

Kỹ thuật khai báo và sử dụng biến trong lập trình VBA

1 bài học thử
7

Cách viết code VBA với đối tượng Range, Cell

1 bài học thử
8

Cách viết code VBA với đối tượng Worksheet

5 bài học thử
9

Cách viết code VBA với đối tượng Workbook

4 bài học thử
10

Các cấu trúc thường gặp trong lập trình VBA

11

Tìm hiểu về vòng lặp trong VBA

12

Các loại lỗi và cách xử lý lỗi khi lập trình

13

Lập trình UserForm cơ bản

2 bài học thử
14

Lập trình sự kiện trong VBA

15

Các bài tập chuyên đề: Ứng dụng VBA trong công việc

16

Kết quả các bài tập chuyên đề: Ứng dụng VBA trong công việc

17

Tài liệu tham khảo - File mẫu sử dụng VBA trong công việc

18

Exam: Đề kiểm tra Kỹ năng Sử dụng VBA

Mô tả khoá học

Từ người mới bắt đầu đến chuyên gia VBA Excel chuẩn Microsoft sau khóa học VBA Excel của Gitiho. 

Hiểu được những khó khăn của việc tự học VBA, trải qua nhiều năm đào tạo hàng ngàn học viên cá nhân và doanh nghiệp, giảng viên Dương Mạnh Quân sẽ cung cấp những bài giảng chi tiết, hướng dẫn từng bước một để học viên có thể thành thạo từng phần, trước khi cung cấp tư duy và phương pháp để xử lý các bài toán tự động hóa công việc, quy trình trên Excel nâng cao

Điều gì tạo nên sự khác biệt để khóa học Tuyệt đỉnh VBA của Gitiho là chương trình học VBA online có nhiều học viên theo học nhất:

  1. Chương trình học chi tiết, đầy đủ với hơn 130 bài giảng và 14+ giờ học VBA.
  2. Dự án + bài tập thực hành chi tiết, đi theo từng chương/phần, giúp người học VBA Excel luôn được thực hành sau khi học.
  3. Ebook, Add-in kèm theo để người học hiểu sức mạnh to lớn của VBA.
  4. Giảng viên hướng dẫn, giải thích từng code chi tiết - luôn hiểu những khó khăn của dân văn phòng học lập trình VBA.
  5. Video chất lượng, luôn cập nhật giao diện, kiến thức mới.

Những kiến thức bạn sẽ thành thạo sau khóa học này:

  • Nắm vững kiến thức nền tảng về VBA.
  • Thành thạo cách sử dụng Macro.
  • Thành thạo viết code với đối tượng Range, Cell.
  • Thành thạo viết code cho Workbook, Worksheet.
  • Lập trình Form.
  • Lập trình sự kiện.
  • Tư duy xử lý các bài toán bằng VBA.
  • Ứng dụng VBA trong công việc thực tế.

Một vài feedback thực tế từ học viên:

“Đây là 1 khóa học VBA rất bổ ích thầy dạy học có kiến thức rất sâu rộng , mình dù là 1 con gà mờ nhưng sau khi học khóa VBA này mình đã học được rất nhiều kỹ năng không chỉ là của vba mà còn các môn học khác, lời cuối cảm ơn công ty và các thầy cô đã cung cấp 1 nội dung học rất bổ ích”

“Bài giảng tuy ngắn gọn nhưng truyền tải được kiến thức trọng tâm. Sự kết hợp giữa clip và giáo trình rất hợp lí, phương thức giảng dạy thực tế với các bài tập mình thấy dễ hiểu và hiệu quả cao. Chắc chắn tôi sẽ đăng kí khóa học VBA2 sau khi tôi hoàn thành các bài tập.”

“Bài giảng kỹ lưỡng, đúng trọng tâm và ứng dụng ngay được. Ban đầu dịch ở nhà chán quá tính học chơi giết thời gian thôi. Cơ mà nó hay với hữu dụng đến bất ngờ. Giờ file excel của mình trông khá gọn gàng, thao tác làm việc cũng dễ chịu hơn, ko phải dụng cái là mất nguyên dòng công thức nữa. Xứng đáng 5 sao.”

“Tôi năm nay cũng 40 tuổi và lần đầu tiếp xúc với VBA, có thể học chậm hơn các bạn trẻ. Nhưng tôi phải nói khóa VBA Excel này rất dễ hiểu, được sự hướng dẫn của các chuyên gia tôi cũng lập được cho mình một phần mềm ứng dụng excel vào việc quản lý công nợ. Sắp tới tôi cũng có kế hoạch tiếp tục học Sql và tạo ribbon quản lý. Tôi hy vọng mình sẽ đạt được thành công hơn nữa. Cảm ơn Gitiho về khóa học VBA rất hay này”

Xem thêm: Tuyệt đỉnh Excel - Trở thành bậc thầy Excel sau 16h

Giảng viên:

G-LEARNING Giảng viên

Trường đào tạo & phát triển kỹ năng ứng dụng tin học văn phòng

G-LEARNING
  • 4.7 điểm đánh giá

  • 491 đánh giá

  • 231,407 học viên

  • 90 khóa học

Đánh giá của học viên

4.84 điểm đánh giá . 64 lượt đánh giá

Pham Thanh Tu

Pham Thanh Tu

10:54 30/11/2022

đây là 1 bài học VBA rất bổ ích thầy dạy học có kiến thức rất sâu rộng, mình dù là 1 con gà mờ nhưng sau khi học mình đã học được rất nhiều kỹ năng không chỉ là của vba mà còn các môn học khác, lời cuối cảm ơn công ty và các thầy cô đã cung cấp 1 nội dung học rất bổ ích . thanks .
Nguyễn Quỳnh Hương

Nguyễn Quỳnh Hương

03:46 04/05/2022

khóa học VBA Excel hữu ích, nhiều ứng dụng thực tế, nhiều bài tập ví dụ và thực hành, dễ hiểu, clip đôi khi hơi bị lag nhưng vẫn không sao, nói chung là cảm thấy hữu ích và hiệu quả, đáng tiền, rất hữu dụng cho công việc
Nguyễn Cảnh Thắng

Nguyễn Cảnh Thắng

01:11 30/11/2021

Khóa học VBA online cung cấp kiến thức đầy đủ trình bày logic giúp người học có thể học theo lộ trình mà không phải bỡ ngỡ. Nội dung thì khỏi phải chê vào đâu được, hi vọng sẽ có nhiều khóa học như này nữa. Good

Thảo luận về bài học

11,525 thảo luận

Đỗ Khánh Sơn

Đỗ Khánh Sơn 27 Jan 2023

Tải về bị thiếu file và không cài đc ạ.

Tuấn Ba

Tuấn Ba [Chuyên gia] 27 Jan 2023

Bạn liên hệ cskh và hẹn lịch hỗ trợ nhé

Nguyễn Văn Thực

Nguyễn Văn Thực 26 Dec 2022

Thầy ơi
Ô Cells(3,2) khi KHÔNG NHẬP GÌ XÓA ĐI NHƯNG   Sheet6.Range("B3:D3").value vẫn có giá trị ạ

E gửi Thầy file đây ạ Thầy chỉ giúp e ạ
Private Sub Worksheet_Change(ByVal Target As Range)
   Dim i As Long
   Dim j As Long
   Dim lr As Long

   With Sheet5
        lr = .Range("B" & Rows.Count).End(xlUp).Row
        i = 3
            For i = 3 To lr
                   If Not Application.Intersect(Target, .Cells(i, 2)) Is Nothing Then
                        If .Cells(i, 2) <> "" Then
                  
                            Sheet6.Cells(i, 2).Value = WorksheetFunction.VLookup(.Cells(i, 2), .Range("B3:D10"), 1, 0)
                            Sheet6.Cells(i, 3).Value = WorksheetFunction.VLookup(.Cells(i, 2), .Range("B3:D10"), 2, 0)
                            Sheet6.Cells(i, 4).Value = WorksheetFunction.VLookup(.Cells(i, 2), .Range("B3:D10"), 3, 0)
                           
                        Else
                          
                            Sheet6.Range("B3:D10").clear
                          
                       End If
                                        
                   End If
         
             Next i
        
     
   End With
   
End Sub

Nguyễn Văn Thực

Nguyễn Văn Thực 26 Dec 2022

NoIDNamePhòng
1 Mr ACS
2 Mr BOQC
3 Mr ACS
4 Mr BOQC
5 Mr ACS
6 Mr BOQC
7 Mr ACS
8 Mr BOQC
NoIDNamePhòng
 1Mr ACS
    
    
    
    
    
    
    

 

{"id":190152,"crm_contact_id":325299,"name":"Nguy\u1ec5n V\u0103n Th\u1ef1c","email":"nvt2810@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"ffcb5861edb1b81ed1112d8531d39d8e","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2021-12-18T02:02:49.000000Z","updated_at":"2022-02-23T15:20:03.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":2,"birthday":null,"position":null,"achievement":null,"full_name":null,"address":"Ph\u1ea1m V\u0103n \u0110\u1ed3ng-C\u1ed5 Nhu\u1ebf1-B\u1eafc T\u1eeb Li\u00eam-H\u00e0 N\u1ed9i","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0965547864","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":30358,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_invalid":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/images\/avatar\/folder_190\/nguyen-thuc.png","link_profile":"https:\/\/gitiho.com\/u\/190152-nguyen-van-thuc","business_employers":[],"vip_account":null,"roles":[]}

Nguyễn Văn Thực 26 Dec 2022

E chưa biết đính kèm tải file lên chỗ nào ạ

{"id":190152,"crm_contact_id":325299,"name":"Nguy\u1ec5n V\u0103n Th\u1ef1c","email":"nvt2810@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"ffcb5861edb1b81ed1112d8531d39d8e","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2021-12-18T02:02:49.000000Z","updated_at":"2022-02-23T15:20:03.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":2,"birthday":null,"position":null,"achievement":null,"full_name":null,"address":"Ph\u1ea1m V\u0103n \u0110\u1ed3ng-C\u1ed5 Nhu\u1ebf1-B\u1eafc T\u1eeb Li\u00eam-H\u00e0 N\u1ed9i","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0965547864","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":30358,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_invalid":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/images\/avatar\/folder_190\/nguyen-thuc.png","link_profile":"https:\/\/gitiho.com\/u\/190152-nguyen-van-thuc","business_employers":[],"vip_account":null,"roles":[]}

Nguyễn Văn Thực 26 Dec 2022

Từ ô B3~B9 khi e xóa data đi data bên sheet6 cũng xóa từ  B3~B9.

 

 

Chỉ còn ô cuối ví dụ ở đây là ô B10 nếu ko có data thì sự kiện change nó ko thực hiện

{"id":74845,"crm_contact_id":53166,"name":"Tu\u1ea5n Ba","email":"laptrinhcchoexcel@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"b4a1dffcd4f5224a3e4df7e7ee0541d5","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-10-02T02:09:45.000000Z","updated_at":"2023-01-27T13:53:20.000000Z","deleted_at":null,"unit_name":"Gitiho","grade":0,"avatar_disk":"public","avatar_path":"users\/1637917341.jpg","gender":0,"birthday":"1992-03-19 00:00:00","position":"Ph\u00e1t tri\u1ec3n \u1ee9ng d\u1ee5ng C# cho Excel","achievement":"<p><br><\/p>","full_name":"L\u01b0\u01a1ng Tu\u00e2\u0301n Ba","address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","status_text":"<p>L\u00e0 T\u00e1c gi\u1ea3 c\u1ee7a Add- Ins Gitiho tools cho ph\u00e9p truy v\u1ea5n d\u1eef li\u1ec7u trong Excel v\u00e0 Access v\u00e0 tr\u1ea3 ra m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u1ed9ng.<\/p>","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":1,"primary_wallet":1010070,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":"118095757772556445137","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1927,"email_invalid":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_number":"2022-03-19","contract_date":"2022-03-18T17:00:00.000000Z","contract_delegate":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","contract_account_number":"19034644336010","contract_bank":"Techcombank","source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1637917341.jpg","link_profile":"https:\/\/gitiho.com\/teacher\/74845-tuan-ba","business_employers":[{"id":12,"biz_business_id":1,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","bizUser":"","avgCompleted":31.87}],"vip_account":null,"roles":[{"id":8,"name":"Teacher","display_name":"Teacher","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":8,"model_type":"App\\Models\\User"}},{"id":13,"name":"ContentManager","display_name":"Qu\u1ea3n l\u00fd n\u1ed9i dung","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-12-21T08:27:44.000000Z","pivot":{"model_id":74845,"role_id":13,"model_type":"App\\Models\\User"}},{"id":19,"name":"GitihoHumanResources","display_name":"GitihoHumanResources","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":19,"model_type":"App\\Models\\User"}}]}

Tuấn Ba [Chuyên gia] 26 Dec 2022

Bạn gửi file lên google drive rồi cho gitiho xin link truy cập nhé.

{"id":190152,"crm_contact_id":325299,"name":"Nguy\u1ec5n V\u0103n Th\u1ef1c","email":"nvt2810@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"ffcb5861edb1b81ed1112d8531d39d8e","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2021-12-18T02:02:49.000000Z","updated_at":"2022-02-23T15:20:03.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":2,"birthday":null,"position":null,"achievement":null,"full_name":null,"address":"Ph\u1ea1m V\u0103n \u0110\u1ed3ng-C\u1ed5 Nhu\u1ebf1-B\u1eafc T\u1eeb Li\u00eam-H\u00e0 N\u1ed9i","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0965547864","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":30358,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_invalid":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/images\/avatar\/folder_190\/nguyen-thuc.png","link_profile":"https:\/\/gitiho.com\/u\/190152-nguyen-van-thuc","business_employers":[],"vip_account":null,"roles":[]}

Nguyễn Văn Thực 26 Dec 2022

E gửi Thầy Link Diver:https://docs.google.com/spreadsheets/d/1yqQQz-uStpICoeXOBJZvisBRYibFlTj6/edit#gid=966059976

{"id":74845,"crm_contact_id":53166,"name":"Tu\u1ea5n Ba","email":"laptrinhcchoexcel@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"b4a1dffcd4f5224a3e4df7e7ee0541d5","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-10-02T02:09:45.000000Z","updated_at":"2023-01-27T13:53:20.000000Z","deleted_at":null,"unit_name":"Gitiho","grade":0,"avatar_disk":"public","avatar_path":"users\/1637917341.jpg","gender":0,"birthday":"1992-03-19 00:00:00","position":"Ph\u00e1t tri\u1ec3n \u1ee9ng d\u1ee5ng C# cho Excel","achievement":"<p><br><\/p>","full_name":"L\u01b0\u01a1ng Tu\u00e2\u0301n Ba","address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","status_text":"<p>L\u00e0 T\u00e1c gi\u1ea3 c\u1ee7a Add- Ins Gitiho tools cho ph\u00e9p truy v\u1ea5n d\u1eef li\u1ec7u trong Excel v\u00e0 Access v\u00e0 tr\u1ea3 ra m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u1ed9ng.<\/p>","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":1,"primary_wallet":1010070,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":"118095757772556445137","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1927,"email_invalid":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_number":"2022-03-19","contract_date":"2022-03-18T17:00:00.000000Z","contract_delegate":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","contract_account_number":"19034644336010","contract_bank":"Techcombank","source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1637917341.jpg","link_profile":"https:\/\/gitiho.com\/teacher\/74845-tuan-ba","business_employers":[{"id":12,"biz_business_id":1,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","bizUser":"","avgCompleted":31.87}],"vip_account":null,"roles":[{"id":8,"name":"Teacher","display_name":"Teacher","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":8,"model_type":"App\\Models\\User"}},{"id":13,"name":"ContentManager","display_name":"Qu\u1ea3n l\u00fd n\u1ed9i dung","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-12-21T08:27:44.000000Z","pivot":{"model_id":74845,"role_id":13,"model_type":"App\\Models\\User"}},{"id":19,"name":"GitihoHumanResources","display_name":"GitihoHumanResources","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":19,"model_type":"App\\Models\\User"}}]}

Tuấn Ba [Chuyên gia] 26 Dec 2022

Bạn cho gitiho xin quyền truy cập nhé.

{"id":190152,"crm_contact_id":325299,"name":"Nguy\u1ec5n V\u0103n Th\u1ef1c","email":"nvt2810@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"ffcb5861edb1b81ed1112d8531d39d8e","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2021-12-18T02:02:49.000000Z","updated_at":"2022-02-23T15:20:03.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":2,"birthday":null,"position":null,"achievement":null,"full_name":null,"address":"Ph\u1ea1m V\u0103n \u0110\u1ed3ng-C\u1ed5 Nhu\u1ebf1-B\u1eafc T\u1eeb Li\u00eam-H\u00e0 N\u1ed9i","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0965547864","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":30358,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_invalid":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/images\/avatar\/folder_190\/nguyen-thuc.png","link_profile":"https:\/\/gitiho.com\/u\/190152-nguyen-van-thuc","business_employers":[],"vip_account":null,"roles":[]}

Nguyễn Văn Thực 27 Dec 2022

E chuyển chế độ mọi người đều có thể truy cập và chỉnh sửa rồi Thầy xem thử có vào được ko ạ.

{"id":190152,"crm_contact_id":325299,"name":"Nguy\u1ec5n V\u0103n Th\u1ef1c","email":"nvt2810@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"ffcb5861edb1b81ed1112d8531d39d8e","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2021-12-18T02:02:49.000000Z","updated_at":"2022-02-23T15:20:03.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":2,"birthday":null,"position":null,"achievement":null,"full_name":null,"address":"Ph\u1ea1m V\u0103n \u0110\u1ed3ng-C\u1ed5 Nhu\u1ebf1-B\u1eafc T\u1eeb Li\u00eam-H\u00e0 N\u1ed9i","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0965547864","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":30358,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_invalid":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/images\/avatar\/folder_190\/nguyen-thuc.png","link_profile":"https:\/\/gitiho.com\/u\/190152-nguyen-van-thuc","business_employers":[],"vip_account":null,"roles":[]}

Nguyễn Văn Thực 27 Dec 2022

E share cả quyền  vào email của Trung Tâm rồi ạ:hotro@gitiho.com

{"id":190152,"crm_contact_id":325299,"name":"Nguy\u1ec5n V\u0103n Th\u1ef1c","email":"nvt2810@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"ffcb5861edb1b81ed1112d8531d39d8e","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2021-12-18T02:02:49.000000Z","updated_at":"2022-02-23T15:20:03.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":2,"birthday":null,"position":null,"achievement":null,"full_name":null,"address":"Ph\u1ea1m V\u0103n \u0110\u1ed3ng-C\u1ed5 Nhu\u1ebf1-B\u1eafc T\u1eeb Li\u00eam-H\u00e0 N\u1ed9i","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0965547864","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":30358,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_invalid":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/images\/avatar\/folder_190\/nguyen-thuc.png","link_profile":"https:\/\/gitiho.com\/u\/190152-nguyen-van-thuc","business_employers":[],"vip_account":null,"roles":[]}

Nguyễn Văn Thực 27 Dec 2022

E gửi lại Thầy Link => e để chế độ mọi người đều có thể chỉnh sửa:
https://docs.google.com/spreadsheets/d/1yqQQz-uStpICoeXOBJZvisBRYibFlTj6/edit?usp=sharing&ouid=100650265315982044903&rtpof=true&sd=true

{"id":66,"crm_contact_id":127658,"name":"D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n","email":"duongquan211287@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2018-11-06 21:53:37","confirmation_code":"d79b40591d95db0a31320b960a8a115c","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2017-05-10T03:17:27.000000Z","updated_at":"2023-01-28T00:56:40.000000Z","deleted_at":null,"unit_name":"Gitiho.com","grade":0,"avatar_disk":"public","avatar_path":"users\/1657593507.jpg","gender":0,"birthday":"1987-12-20 07:00:00","position":"Chuy\u00ean gia excel","achievement":null,"full_name":"D\u01b0\u01a1ng Qu\u00e2n","address":"Gitiho.com","status_text":"<p>Gi\u1ea3ng vi\u00ean: D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n<\/p><p>- N\u01a1i c\u00f4ng t\u00e1c hi\u1ec7n t\u1ea1i: Chuy\u00ean gia gi\u00e1o d\u1ee5c t\u1ea1i Gitiho.com<\/p><p><span style=\"color: rgb(0, 0, 0);\">- T\u1eebng l\u00e0m k\u1ebf to\u00e1n qu\u1ea3n tr\u1ecb t\u1ea1i c\u00f4ng ty TNHH DTK'Vina, tr\u1ef1c thu\u1ed9c t\u1eadp&nbsp;\u0111o\u00e0n DEAHO, H\u00e0n Qu\u1ed1c.<\/span><br><\/p><p>- H\u01a1n 7 n\u0103m kinh nghi\u1ec7m l\u00e0m vi\u1ec7c v\u1edbi&nbsp;excel trong l\u0129nh v\u1ef1c k\u1ebf to\u00e1n, t\u00e0i ch\u00ednh<\/p><p>- X\u00e2y d\u1ef1ng nhi\u1ec1u ph\u1ea7n m\u1ec1m&nbsp;excel trong c\u00e1c l\u0129nh v\u1ef1c: K\u1ebf to\u00e1n kho, k\u1ebf to\u00e1n c\u00f4ng n\u1ee3, k\u1ebf to\u00e1n ti\u1ec1n l\u01b0\u01a1ng... trong nhi\u1ec1u lo\u1ea1i h\u00ecnh doanh nghi\u1ec7p kh\u00e1c nhau.<\/p><p>- X\u00e2y d\u1ef1ng ph\u1ea7n m\u1ec1m&nbsp;excel trong l\u0129nh v\u1ef1c t\u00e0i ch\u00ednh: l\u1eadp ph\u01b0\u01a1ng&nbsp;\u00e1n kinh doanh, qu\u1ea3n tr\u1ecb d\u00f2ng ti\u1ec1n trong doanh nghi\u1ec7p...<\/p><p>- T\u01b0 v\u1ea5n gi\u1ea3i ph\u00e1p ho\u00e0n thi\u1ec7n quy tr\u00ecnh qu\u1ea3n l\u00fd doanh nghi\u1ec7p,&nbsp;\u00e1p d\u1ee5ng ph\u1ea7n m\u1ec1m&nbsp;excel n\u00e2ng cao hi\u1ec7u su\u1ea5t l\u00e0m vi\u1ec7c.<\/p><p><br><\/p>","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0977705162","become_teacher":0,"primary_wallet":54153591,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":"103589301897268320461","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1442,"email_invalid":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":"D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n","contract_number":"2022\/GITIHO-DUONGQUAN","contract_date":"2019-12-31T17:00:00.000000Z","contract_delegate":"D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n","contract_address":"24 ng\u00e1ch 9 ng\u00f5 162A T\u00f4n \u0110\u1ee9c Th\u1eafng, \u0110\u1ed1ng \u0110a, H\u00e0 N\u1ed9i","contract_account_number":"19033577541015","contract_bank":"Techcombank","source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1657593507.jpg","link_profile":"https:\/\/gitiho.com\/teacher\/66-duong-manh-quan","business_employers":[{"id":33,"biz_business_id":1,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","bizUser":"","avgCompleted":8.83}],"vip_account":null,"roles":[{"id":8,"name":"Teacher","display_name":"Teacher","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":66,"role_id":8,"model_type":"App\\Models\\User"}},{"id":15,"name":"BlogManager","display_name":"BlogManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":66,"role_id":15,"model_type":"App\\Models\\User"}},{"id":17,"name":"partnerAffiliate","display_name":"partnerAffiliate","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":66,"role_id":17,"model_type":"App\\Models\\User"}},{"id":19,"name":"GitihoHumanResources","display_name":"GitihoHumanResources","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":66,"role_id":19,"model_type":"App\\Models\\User"}}]}

Dương Mạnh Quân [Chuyên gia] 27 Dec 2022

Bạn đang lập trình cho sự kiện Worksheet_change trong sheet5.

Theo mình thấy câu lệnh For cần đặt trong đoạn IF giới hạn nơi diễn ra sự kiện (điều chỉnh lại thứ tự này).

Hàm VLOOKUP bạn viết cũng chưa đúng. Cột nhận kết quả phải luôn lớn hơn 1 nhé (dòng vlookup đầu tiên bị sai).

{"id":190152,"crm_contact_id":325299,"name":"Nguy\u1ec5n V\u0103n Th\u1ef1c","email":"nvt2810@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"ffcb5861edb1b81ed1112d8531d39d8e","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2021-12-18T02:02:49.000000Z","updated_at":"2022-02-23T15:20:03.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":2,"birthday":null,"position":null,"achievement":null,"full_name":null,"address":"Ph\u1ea1m V\u0103n \u0110\u1ed3ng-C\u1ed5 Nhu\u1ebf1-B\u1eafc T\u1eeb Li\u00eam-H\u00e0 N\u1ed9i","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0965547864","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":30358,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_invalid":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/images\/avatar\/folder_190\/nguyen-thuc.png","link_profile":"https:\/\/gitiho.com\/u\/190152-nguyen-van-thuc","business_employers":[],"vip_account":null,"roles":[]}

Nguyễn Văn Thực 27 Dec 2022

E cảm ơn Thầy!

{"id":190152,"crm_contact_id":325299,"name":"Nguy\u1ec5n V\u0103n Th\u1ef1c","email":"nvt2810@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"ffcb5861edb1b81ed1112d8531d39d8e","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2021-12-18T02:02:49.000000Z","updated_at":"2022-02-23T15:20:03.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":2,"birthday":null,"position":null,"achievement":null,"full_name":null,"address":"Ph\u1ea1m V\u0103n \u0110\u1ed3ng-C\u1ed5 Nhu\u1ebf1-B\u1eafc T\u1eeb Li\u00eam-H\u00e0 N\u1ed9i","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0965547864","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":30358,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_invalid":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/images\/avatar\/folder_190\/nguyen-thuc.png","link_profile":"https:\/\/gitiho.com\/u\/190152-nguyen-van-thuc","business_employers":[],"vip_account":null,"roles":[]}

Nguyễn Văn Thực 19 Jan 2023

Thầy ơi

Ứng dụng MẢNG rất hay.
Nhưng khó => chúng e chưa hiểu.
Thầy làm thêm các bài giảng về MẢNG ạ.

{"id":74845,"crm_contact_id":53166,"name":"Tu\u1ea5n Ba","email":"laptrinhcchoexcel@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"b4a1dffcd4f5224a3e4df7e7ee0541d5","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-10-02T02:09:45.000000Z","updated_at":"2023-01-27T13:53:20.000000Z","deleted_at":null,"unit_name":"Gitiho","grade":0,"avatar_disk":"public","avatar_path":"users\/1637917341.jpg","gender":0,"birthday":"1992-03-19 00:00:00","position":"Ph\u00e1t tri\u1ec3n \u1ee9ng d\u1ee5ng C# cho Excel","achievement":"<p><br><\/p>","full_name":"L\u01b0\u01a1ng Tu\u00e2\u0301n Ba","address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","status_text":"<p>L\u00e0 T\u00e1c gi\u1ea3 c\u1ee7a Add- Ins Gitiho tools cho ph\u00e9p truy v\u1ea5n d\u1eef li\u1ec7u trong Excel v\u00e0 Access v\u00e0 tr\u1ea3 ra m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u1ed9ng.<\/p>","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":1,"primary_wallet":1010070,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":"118095757772556445137","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1927,"email_invalid":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_number":"2022-03-19","contract_date":"2022-03-18T17:00:00.000000Z","contract_delegate":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","contract_account_number":"19034644336010","contract_bank":"Techcombank","source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1637917341.jpg","link_profile":"https:\/\/gitiho.com\/teacher\/74845-tuan-ba","business_employers":[{"id":12,"biz_business_id":1,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","bizUser":"","avgCompleted":31.87}],"vip_account":null,"roles":[{"id":8,"name":"Teacher","display_name":"Teacher","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":8,"model_type":"App\\Models\\User"}},{"id":13,"name":"ContentManager","display_name":"Qu\u1ea3n l\u00fd n\u1ed9i dung","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-12-21T08:27:44.000000Z","pivot":{"model_id":74845,"role_id":13,"model_type":"App\\Models\\User"}},{"id":19,"name":"GitihoHumanResources","display_name":"GitihoHumanResources","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":19,"model_type":"App\\Models\\User"}}]}

Tuấn Ba [Chuyên gia] 20 Jan 2023

Bạn xem trong khóa vbag02 nhé 

Ngô Thị Kim Chung

Ngô Thị Kim Chung 16 Jan 2023

Kính gừi thầy! laftop của em: bấm F4 không cố định ô bằng dấu $, vậy bấm phím nào để cố định ô vậy ?
Tuấn Ba

Tuấn Ba [Chuyên gia] 17 Jan 2023

Chào bạn bạn bấm Fn+F4 nhé.

dieuanh199952@gmail.com

dieuanh199952@gmail.com 15 Jan 2023

Thầy có thể xem cho em viết sai đoạn code ở chỗ nào được ko ạ mà em cứ bị bắt sai ở chỗ này

Sheets("PhieuLuong").Range("F6").Value = Sheets("Data_TienLuong").Range("E" & i).Value

Tuấn Ba

Tuấn Ba [Chuyên gia] 15 Jan 2023

Bạn đẩy file lên giúp gitiho bạn nhé.

{"id":66,"crm_contact_id":127658,"name":"D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n","email":"duongquan211287@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2018-11-06 21:53:37","confirmation_code":"d79b40591d95db0a31320b960a8a115c","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2017-05-10T03:17:27.000000Z","updated_at":"2023-01-28T00:56:40.000000Z","deleted_at":null,"unit_name":"Gitiho.com","grade":0,"avatar_disk":"public","avatar_path":"users\/1657593507.jpg","gender":0,"birthday":"1987-12-20 07:00:00","position":"Chuy\u00ean gia excel","achievement":null,"full_name":"D\u01b0\u01a1ng Qu\u00e2n","address":"Gitiho.com","status_text":"<p>Gi\u1ea3ng vi\u00ean: D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n<\/p><p>- N\u01a1i c\u00f4ng t\u00e1c hi\u1ec7n t\u1ea1i: Chuy\u00ean gia gi\u00e1o d\u1ee5c t\u1ea1i Gitiho.com<\/p><p><span style=\"color: rgb(0, 0, 0);\">- T\u1eebng l\u00e0m k\u1ebf to\u00e1n qu\u1ea3n tr\u1ecb t\u1ea1i c\u00f4ng ty TNHH DTK'Vina, tr\u1ef1c thu\u1ed9c t\u1eadp&nbsp;\u0111o\u00e0n DEAHO, H\u00e0n Qu\u1ed1c.<\/span><br><\/p><p>- H\u01a1n 7 n\u0103m kinh nghi\u1ec7m l\u00e0m vi\u1ec7c v\u1edbi&nbsp;excel trong l\u0129nh v\u1ef1c k\u1ebf to\u00e1n, t\u00e0i ch\u00ednh<\/p><p>- X\u00e2y d\u1ef1ng nhi\u1ec1u ph\u1ea7n m\u1ec1m&nbsp;excel trong c\u00e1c l\u0129nh v\u1ef1c: K\u1ebf to\u00e1n kho, k\u1ebf to\u00e1n c\u00f4ng n\u1ee3, k\u1ebf to\u00e1n ti\u1ec1n l\u01b0\u01a1ng... trong nhi\u1ec1u lo\u1ea1i h\u00ecnh doanh nghi\u1ec7p kh\u00e1c nhau.<\/p><p>- X\u00e2y d\u1ef1ng ph\u1ea7n m\u1ec1m&nbsp;excel trong l\u0129nh v\u1ef1c t\u00e0i ch\u00ednh: l\u1eadp ph\u01b0\u01a1ng&nbsp;\u00e1n kinh doanh, qu\u1ea3n tr\u1ecb d\u00f2ng ti\u1ec1n trong doanh nghi\u1ec7p...<\/p><p>- T\u01b0 v\u1ea5n gi\u1ea3i ph\u00e1p ho\u00e0n thi\u1ec7n quy tr\u00ecnh qu\u1ea3n l\u00fd doanh nghi\u1ec7p,&nbsp;\u00e1p d\u1ee5ng ph\u1ea7n m\u1ec1m&nbsp;excel n\u00e2ng cao hi\u1ec7u su\u1ea5t l\u00e0m vi\u1ec7c.<\/p><p><br><\/p>","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0977705162","become_teacher":0,"primary_wallet":54153591,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":"103589301897268320461","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1442,"email_invalid":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":"D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n","contract_number":"2022\/GITIHO-DUONGQUAN","contract_date":"2019-12-31T17:00:00.000000Z","contract_delegate":"D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n","contract_address":"24 ng\u00e1ch 9 ng\u00f5 162A T\u00f4n \u0110\u1ee9c Th\u1eafng, \u0110\u1ed1ng \u0110a, H\u00e0 N\u1ed9i","contract_account_number":"19033577541015","contract_bank":"Techcombank","source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1657593507.jpg","link_profile":"https:\/\/gitiho.com\/teacher\/66-duong-manh-quan","business_employers":[{"id":33,"biz_business_id":1,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","bizUser":"","avgCompleted":8.83}],"vip_account":null,"roles":[{"id":8,"name":"Teacher","display_name":"Teacher","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":66,"role_id":8,"model_type":"App\\Models\\User"}},{"id":15,"name":"BlogManager","display_name":"BlogManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":66,"role_id":15,"model_type":"App\\Models\\User"}},{"id":17,"name":"partnerAffiliate","display_name":"partnerAffiliate","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":66,"role_id":17,"model_type":"App\\Models\\User"}},{"id":19,"name":"GitihoHumanResources","display_name":"GitihoHumanResources","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":66,"role_id":19,"model_type":"App\\Models\\User"}}]}

Dương Mạnh Quân [Chuyên gia] 16 Jan 2023

Bạn thử kiểm tra lại:

  • Giá trị Dòng đầu và dòng cuối: dòng cuối phải lớn hơn dòng đầu.
  • Dấu nháy kép khi viết tên sheet, tên tọa độ trong range cần sử dụng đúng là dấu nháy kép nhé.

Rồi bạn có thể bấm phím f8 để kiểm tra từng dòng code xem cụ thể lỗi ở đâu.

dieuanh199952@gmail.com

dieuanh199952@gmail.com 13 Jan 2023

Em không thể nào mở được userform sau khi dán macro vào shape

dieuanh199952@gmail.com

dieuanh199952@gmail.com 13 Jan 2023

nó chỉ ra đoạn vàng này nhưng e không rõ sai ở đâu ạ

{"id":74845,"crm_contact_id":53166,"name":"Tu\u1ea5n Ba","email":"laptrinhcchoexcel@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"b4a1dffcd4f5224a3e4df7e7ee0541d5","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-10-02T02:09:45.000000Z","updated_at":"2023-01-27T13:53:20.000000Z","deleted_at":null,"unit_name":"Gitiho","grade":0,"avatar_disk":"public","avatar_path":"users\/1637917341.jpg","gender":0,"birthday":"1992-03-19 00:00:00","position":"Ph\u00e1t tri\u1ec3n \u1ee9ng d\u1ee5ng C# cho Excel","achievement":"<p><br><\/p>","full_name":"L\u01b0\u01a1ng Tu\u00e2\u0301n Ba","address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","status_text":"<p>L\u00e0 T\u00e1c gi\u1ea3 c\u1ee7a Add- Ins Gitiho tools cho ph\u00e9p truy v\u1ea5n d\u1eef li\u1ec7u trong Excel v\u00e0 Access v\u00e0 tr\u1ea3 ra m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u1ed9ng.<\/p>","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":1,"primary_wallet":1010070,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":"118095757772556445137","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1927,"email_invalid":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_number":"2022-03-19","contract_date":"2022-03-18T17:00:00.000000Z","contract_delegate":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","contract_account_number":"19034644336010","contract_bank":"Techcombank","source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1637917341.jpg","link_profile":"https:\/\/gitiho.com\/teacher\/74845-tuan-ba","business_employers":[{"id":12,"biz_business_id":1,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","bizUser":"","avgCompleted":31.87}],"vip_account":null,"roles":[{"id":8,"name":"Teacher","display_name":"Teacher","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":8,"model_type":"App\\Models\\User"}},{"id":13,"name":"ContentManager","display_name":"Qu\u1ea3n l\u00fd n\u1ed9i dung","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-12-21T08:27:44.000000Z","pivot":{"model_id":74845,"role_id":13,"model_type":"App\\Models\\User"}},{"id":19,"name":"GitihoHumanResources","display_name":"GitihoHumanResources","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":19,"model_type":"App\\Models\\User"}}]}

Tuấn Ba [Chuyên gia] 13 Jan 2023

bạn đẩy file lên giúp gitiho nhé

{"id":251122,"crm_contact_id":438548,"name":"dieuanh199952@gmail.com","email":"dieuanh199952@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2022-10-17 15:37:00","confirmation_code":"d59c90903d9e55582829c1a663b7ecde","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2022-10-04T07:26:19.000000Z","updated_at":"2023-01-13T09:20:20.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":2,"birthday":null,"position":null,"achievement":null,"full_name":"dieuanh199952@gmail.com","address":null,"status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":29449,"google_id":"117127447706941968677","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1,"email_invalid":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/images\/avatar\/folder_251\/dieuanh199952-at-gmailcom-dieuanh199952-at-gmailcom.png","link_profile":"https:\/\/gitiho.com\/u\/251122-dieuanh199952-at-gmailcom","business_employers":[],"vip_account":null,"roles":[]}

dieuanh199952@gmail.com 13 Jan 2023

Private Sub Cmb_Dong_Click()
Unload Me
End Sub

Private Sub Cmb_Luu_Click()
Dim DongCuoi As Long
DongCuoi = Sheets("Sheet1").Range("G" & Rows.Count).End(xlUp).Row
With Sheets("Sheet1")
.Range("G" & DongCuoi + 1) = Tb_HoTen
.Range("H" & DongCuoi + 1) = CDate(Tb_NgaySinh)
.Range("I" & DongCuoi + 1) = Cb_BoPhan
.Range("J" & DongCuoi + 1) = Tb_SoNgayCong
.Range("K" & DongCuoi + 1) = Tb_MucLuong
.Range("K" & DongCuoi + 1) = Tb_TienLuong

End With

End Sub

Private Sub Tb_HoTen_Change()
Tb_HoTen = StrConv(Tb_HoTen, vbProperCase)
End Sub
Private Sub Tb_MucLuong_Change()
Tb_MucLuong = Format(Tb_MucLuong, "#,##0")
If Tb_MucLuong <> "" And Tb_NgayCong <> "" Then
Tb_TienLuong = Tb_NgayCong * Tb_MucLuong
End If
End Sub

Private Sub Tb_NgayCong_Change()
If Tb_NgayCong <> "" And Tb_MucLuong <> "" Then
Tb_TienLuong = Tb_NgayCong * Tb_MucLuong
End If
End Sub
Private Sub Tb_NgaySinh_AfterUpdate()
Tb_NgaySinh = Format(Tb_NgaySinh, "dd/mm/yyyy")
End Sub
Private Sub UserForm_Initialize()
Dim ChonTen As Object
For Each ChonTen In Sheets("Sheet1").Range("Bo_Phan")
Cb_BoPhan.AddItem ChonTen
Next
End Sub

{"id":74845,"crm_contact_id":53166,"name":"Tu\u1ea5n Ba","email":"laptrinhcchoexcel@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"b4a1dffcd4f5224a3e4df7e7ee0541d5","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-10-02T02:09:45.000000Z","updated_at":"2023-01-27T13:53:20.000000Z","deleted_at":null,"unit_name":"Gitiho","grade":0,"avatar_disk":"public","avatar_path":"users\/1637917341.jpg","gender":0,"birthday":"1992-03-19 00:00:00","position":"Ph\u00e1t tri\u1ec3n \u1ee9ng d\u1ee5ng C# cho Excel","achievement":"<p><br><\/p>","full_name":"L\u01b0\u01a1ng Tu\u00e2\u0301n Ba","address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","status_text":"<p>L\u00e0 T\u00e1c gi\u1ea3 c\u1ee7a Add- Ins Gitiho tools cho ph\u00e9p truy v\u1ea5n d\u1eef li\u1ec7u trong Excel v\u00e0 Access v\u00e0 tr\u1ea3 ra m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u1ed9ng.<\/p>","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":1,"primary_wallet":1010070,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":"118095757772556445137","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1927,"email_invalid":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_number":"2022-03-19","contract_date":"2022-03-18T17:00:00.000000Z","contract_delegate":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","contract_account_number":"19034644336010","contract_bank":"Techcombank","source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1637917341.jpg","link_profile":"https:\/\/gitiho.com\/teacher\/74845-tuan-ba","business_employers":[{"id":12,"biz_business_id":1,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","bizUser":"","avgCompleted":31.87}],"vip_account":null,"roles":[{"id":8,"name":"Teacher","display_name":"Teacher","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":8,"model_type":"App\\Models\\User"}},{"id":13,"name":"ContentManager","display_name":"Qu\u1ea3n l\u00fd n\u1ed9i dung","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-12-21T08:27:44.000000Z","pivot":{"model_id":74845,"role_id":13,"model_type":"App\\Models\\User"}},{"id":19,"name":"GitihoHumanResources","display_name":"GitihoHumanResources","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":19,"model_type":"App\\Models\\User"}}]}

Tuấn Ba [Chuyên gia] 13 Jan 2023

Bạn đẩy file lên gitiho mới dubug dc bạn nhé

{"id":251122,"crm_contact_id":438548,"name":"dieuanh199952@gmail.com","email":"dieuanh199952@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2022-10-17 15:37:00","confirmation_code":"d59c90903d9e55582829c1a663b7ecde","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2022-10-04T07:26:19.000000Z","updated_at":"2023-01-13T09:20:20.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":2,"birthday":null,"position":null,"achievement":null,"full_name":"dieuanh199952@gmail.com","address":null,"status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":29449,"google_id":"117127447706941968677","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1,"email_invalid":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/images\/avatar\/folder_251\/dieuanh199952-at-gmailcom-dieuanh199952-at-gmailcom.png","link_profile":"https:\/\/gitiho.com\/u\/251122-dieuanh199952-at-gmailcom","business_employers":[],"vip_account":null,"roles":[]}

dieuanh199952@gmail.com 13 Jan 2023

mình đẩy file như thế nào ạ

 

{"id":74845,"crm_contact_id":53166,"name":"Tu\u1ea5n Ba","email":"laptrinhcchoexcel@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"b4a1dffcd4f5224a3e4df7e7ee0541d5","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-10-02T02:09:45.000000Z","updated_at":"2023-01-27T13:53:20.000000Z","deleted_at":null,"unit_name":"Gitiho","grade":0,"avatar_disk":"public","avatar_path":"users\/1637917341.jpg","gender":0,"birthday":"1992-03-19 00:00:00","position":"Ph\u00e1t tri\u1ec3n \u1ee9ng d\u1ee5ng C# cho Excel","achievement":"<p><br><\/p>","full_name":"L\u01b0\u01a1ng Tu\u00e2\u0301n Ba","address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","status_text":"<p>L\u00e0 T\u00e1c gi\u1ea3 c\u1ee7a Add- Ins Gitiho tools cho ph\u00e9p truy v\u1ea5n d\u1eef li\u1ec7u trong Excel v\u00e0 Access v\u00e0 tr\u1ea3 ra m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u1ed9ng.<\/p>","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":1,"primary_wallet":1010070,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":"118095757772556445137","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1927,"email_invalid":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_number":"2022-03-19","contract_date":"2022-03-18T17:00:00.000000Z","contract_delegate":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","contract_account_number":"19034644336010","contract_bank":"Techcombank","source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1637917341.jpg","link_profile":"https:\/\/gitiho.com\/teacher\/74845-tuan-ba","business_employers":[{"id":12,"biz_business_id":1,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","bizUser":"","avgCompleted":31.87}],"vip_account":null,"roles":[{"id":8,"name":"Teacher","display_name":"Teacher","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":8,"model_type":"App\\Models\\User"}},{"id":13,"name":"ContentManager","display_name":"Qu\u1ea3n l\u00fd n\u1ed9i dung","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-12-21T08:27:44.000000Z","pivot":{"model_id":74845,"role_id":13,"model_type":"App\\Models\\User"}},{"id":19,"name":"GitihoHumanResources","display_name":"GitihoHumanResources","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":19,"model_type":"App\\Models\\User"}}]}

Tuấn Ba [Chuyên gia] 14 Jan 2023

Chào bạn bạn đẩy file lên google drive rồi cho gitiho xin link truy cập nhé.

Dương Tấn Phước

Dương Tấn Phước 11 Jan 2023

Tuấn Ba

Tuấn Ba [Chuyên gia] 11 Jan 2023

bạn kích chuột phải  vào khung đó và làm như hình

dieuanh199952@gmail.com

dieuanh199952@gmail.com 10 Jan 2023

Em đang thử luyện tập sử dụng vòng lặp để gộp dữ liệu từ nhiều file nhưng mà không hiểu sao khi chạy lại không tìm thấy file để chọn ạ?

dieuanh199952@gmail.com

dieuanh199952@gmail.com 10 Jan 2023

mà rõ ràng em đã gộp các workbook về một folder rồi ạ

{"id":74845,"crm_contact_id":53166,"name":"Tu\u1ea5n Ba","email":"laptrinhcchoexcel@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"b4a1dffcd4f5224a3e4df7e7ee0541d5","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-10-02T02:09:45.000000Z","updated_at":"2023-01-27T13:53:20.000000Z","deleted_at":null,"unit_name":"Gitiho","grade":0,"avatar_disk":"public","avatar_path":"users\/1637917341.jpg","gender":0,"birthday":"1992-03-19 00:00:00","position":"Ph\u00e1t tri\u1ec3n \u1ee9ng d\u1ee5ng C# cho Excel","achievement":"<p><br><\/p>","full_name":"L\u01b0\u01a1ng Tu\u00e2\u0301n Ba","address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","status_text":"<p>L\u00e0 T\u00e1c gi\u1ea3 c\u1ee7a Add- Ins Gitiho tools cho ph\u00e9p truy v\u1ea5n d\u1eef li\u1ec7u trong Excel v\u00e0 Access v\u00e0 tr\u1ea3 ra m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u1ed9ng.<\/p>","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":1,"primary_wallet":1010070,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":"118095757772556445137","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1927,"email_invalid":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_number":"2022-03-19","contract_date":"2022-03-18T17:00:00.000000Z","contract_delegate":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","contract_account_number":"19034644336010","contract_bank":"Techcombank","source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1637917341.jpg","link_profile":"https:\/\/gitiho.com\/teacher\/74845-tuan-ba","business_employers":[{"id":12,"biz_business_id":1,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","bizUser":"","avgCompleted":31.87}],"vip_account":null,"roles":[{"id":8,"name":"Teacher","display_name":"Teacher","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":8,"model_type":"App\\Models\\User"}},{"id":13,"name":"ContentManager","display_name":"Qu\u1ea3n l\u00fd n\u1ed9i dung","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-12-21T08:27:44.000000Z","pivot":{"model_id":74845,"role_id":13,"model_type":"App\\Models\\User"}},{"id":19,"name":"GitihoHumanResources","display_name":"GitihoHumanResources","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":19,"model_type":"App\\Models\\User"}}]}

Tuấn Ba [Chuyên gia] 11 Jan 2023

Chào bạn bạn có thể đẩy code lên được không hoặc xem file này

https://drive.google.com/file/d/1ZfKQQa91N-mIoUsupoiT3ibxjDNAzerv/view?usp=sharing

{"id":251122,"crm_contact_id":438548,"name":"dieuanh199952@gmail.com","email":"dieuanh199952@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2022-10-17 15:37:00","confirmation_code":"d59c90903d9e55582829c1a663b7ecde","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2022-10-04T07:26:19.000000Z","updated_at":"2023-01-13T09:20:20.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":2,"birthday":null,"position":null,"achievement":null,"full_name":"dieuanh199952@gmail.com","address":null,"status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":29449,"google_id":"117127447706941968677","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1,"email_invalid":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/images\/avatar\/folder_251\/dieuanh199952-at-gmailcom-dieuanh199952-at-gmailcom.png","link_profile":"https:\/\/gitiho.com\/u\/251122-dieuanh199952-at-gmailcom","business_employers":[],"vip_account":null,"roles":[]}

dieuanh199952@gmail.com 11 Jan 2023

Code là phần phía bên tay phải hình ảnh ấy ạ

{"id":251122,"crm_contact_id":438548,"name":"dieuanh199952@gmail.com","email":"dieuanh199952@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2022-10-17 15:37:00","confirmation_code":"d59c90903d9e55582829c1a663b7ecde","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2022-10-04T07:26:19.000000Z","updated_at":"2023-01-13T09:20:20.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":2,"birthday":null,"position":null,"achievement":null,"full_name":"dieuanh199952@gmail.com","address":null,"status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":29449,"google_id":"117127447706941968677","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1,"email_invalid":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/images\/avatar\/folder_251\/dieuanh199952-at-gmailcom-dieuanh199952-at-gmailcom.png","link_profile":"https:\/\/gitiho.com\/u\/251122-dieuanh199952-at-gmailcom","business_employers":[],"vip_account":null,"roles":[]}

dieuanh199952@gmail.com 11 Jan 2023

Sub Gop_File01()
'Hien thi cua so de minh chon fil
With Application.FileDialog(msoFileDialogFolderPicker)
.AllowMultiSelect = True
.Show
Dim i As Integer
For i = 1 To .SelectedItems.Count
Dim wb_KQ As Workbook
Dim wb_file_01 As Workbook
Set wb_KQ = ThisWorkbook
Set wb_file_01 = Workbooks.Open(.SelectedItems(i))

Dim DongCuoi_KQ As Long
DongCuoi_KQ = ThisWorkbook.Sheets("Data_TiengLuong").Range("A" & Rows.Count).End(xlUp).Row
Dim DongDau As Long
DongDau = 8
Dim DongCuoi As Long
DongCuoi = wb_file_01.Sheets(1).Range("A" & Rows.Count).End(xlUp).Row
Dim Khoang_cach As Long
Khoang_cach = DongCuoi - DongDau + 1

wb_KQ.Range("A" & DongCuoi_KQ + 1 & ":BM" & DongCuoi_KQ + KhoangCach).Value _
= wb_file_01.Sheets(1).Range("A" & DongDau & ":BM" & DongCuoi).Value
MsgBox "Nhap Du Lieu Thanh Cong"
Next i
End With
End Sub

{"id":66,"crm_contact_id":127658,"name":"D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n","email":"duongquan211287@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2018-11-06 21:53:37","confirmation_code":"d79b40591d95db0a31320b960a8a115c","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2017-05-10T03:17:27.000000Z","updated_at":"2023-01-28T00:56:40.000000Z","deleted_at":null,"unit_name":"Gitiho.com","grade":0,"avatar_disk":"public","avatar_path":"users\/1657593507.jpg","gender":0,"birthday":"1987-12-20 07:00:00","position":"Chuy\u00ean gia excel","achievement":null,"full_name":"D\u01b0\u01a1ng Qu\u00e2n","address":"Gitiho.com","status_text":"<p>Gi\u1ea3ng vi\u00ean: D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n<\/p><p>- N\u01a1i c\u00f4ng t\u00e1c hi\u1ec7n t\u1ea1i: Chuy\u00ean gia gi\u00e1o d\u1ee5c t\u1ea1i Gitiho.com<\/p><p><span style=\"color: rgb(0, 0, 0);\">- T\u1eebng l\u00e0m k\u1ebf to\u00e1n qu\u1ea3n tr\u1ecb t\u1ea1i c\u00f4ng ty TNHH DTK'Vina, tr\u1ef1c thu\u1ed9c t\u1eadp&nbsp;\u0111o\u00e0n DEAHO, H\u00e0n Qu\u1ed1c.<\/span><br><\/p><p>- H\u01a1n 7 n\u0103m kinh nghi\u1ec7m l\u00e0m vi\u1ec7c v\u1edbi&nbsp;excel trong l\u0129nh v\u1ef1c k\u1ebf to\u00e1n, t\u00e0i ch\u00ednh<\/p><p>- X\u00e2y d\u1ef1ng nhi\u1ec1u ph\u1ea7n m\u1ec1m&nbsp;excel trong c\u00e1c l\u0129nh v\u1ef1c: K\u1ebf to\u00e1n kho, k\u1ebf to\u00e1n c\u00f4ng n\u1ee3, k\u1ebf to\u00e1n ti\u1ec1n l\u01b0\u01a1ng... trong nhi\u1ec1u lo\u1ea1i h\u00ecnh doanh nghi\u1ec7p kh\u00e1c nhau.<\/p><p>- X\u00e2y d\u1ef1ng ph\u1ea7n m\u1ec1m&nbsp;excel trong l\u0129nh v\u1ef1c t\u00e0i ch\u00ednh: l\u1eadp ph\u01b0\u01a1ng&nbsp;\u00e1n kinh doanh, qu\u1ea3n tr\u1ecb d\u00f2ng ti\u1ec1n trong doanh nghi\u1ec7p...<\/p><p>- T\u01b0 v\u1ea5n gi\u1ea3i ph\u00e1p ho\u00e0n thi\u1ec7n quy tr\u00ecnh qu\u1ea3n l\u00fd doanh nghi\u1ec7p,&nbsp;\u00e1p d\u1ee5ng ph\u1ea7n m\u1ec1m&nbsp;excel n\u00e2ng cao hi\u1ec7u su\u1ea5t l\u00e0m vi\u1ec7c.<\/p><p><br><\/p>","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0977705162","become_teacher":0,"primary_wallet":54153591,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":"103589301897268320461","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1442,"email_invalid":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":"D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n","contract_number":"2022\/GITIHO-DUONGQUAN","contract_date":"2019-12-31T17:00:00.000000Z","contract_delegate":"D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n","contract_address":"24 ng\u00e1ch 9 ng\u00f5 162A T\u00f4n \u0110\u1ee9c Th\u1eafng, \u0110\u1ed1ng \u0110a, H\u00e0 N\u1ed9i","contract_account_number":"19033577541015","contract_bank":"Techcombank","source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1657593507.jpg","link_profile":"https:\/\/gitiho.com\/teacher\/66-duong-manh-quan","business_employers":[{"id":33,"biz_business_id":1,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","bizUser":"","avgCompleted":8.83}],"vip_account":null,"roles":[{"id":8,"name":"Teacher","display_name":"Teacher","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":66,"role_id":8,"model_type":"App\\Models\\User"}},{"id":15,"name":"BlogManager","display_name":"BlogManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":66,"role_id":15,"model_type":"App\\Models\\User"}},{"id":17,"name":"partnerAffiliate","display_name":"partnerAffiliate","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":66,"role_id":17,"model_type":"App\\Models\\User"}},{"id":19,"name":"GitihoHumanResources","display_name":"GitihoHumanResources","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":66,"role_id":19,"model_type":"App\\Models\\User"}}]}

Dương Mạnh Quân [Chuyên gia] 11 Jan 2023

Bạn đang viết code theo: Application.FileDialog(msoFileDialogFolderPicker) tức là chọn folder, không phải chọn file.

Bạn viết theo FilePicker nhé.

Phan Quỳnh Thương

Phan Quỳnh Thương 11 Jan 2023

Thầy cho e hỏi với cách xác định dòng cuối để tìm dòng định dạng, thì viết dòng cuối + 1 như thế nào là đúng ạ?
E viết như sau ko chạy được ?
Sub Dongtongcong_vietlai()
Dim Dongcuoi As Long
Dongcuoi = Sheets("sheet2").Range("B" & Rows.Count).End(xlUp).Row
Range("Dongcuoi" + 1).Style = "Total"
End Sub

Dương Mạnh Quân

Dương Mạnh Quân [Chuyên gia] 11 Jan 2023

Biến dòng cuối ở dạng Long tức là 1 con số.

Dongcuoi + 1 cũng là 1 con số, thể hiện số dòng.

Khi viết Range phải xác định cả cột và dòng. Do đó code định dạng ở cuối sẽ viết dạng:

Range("A" & dongcuoi + 1 & “:H” & dongcuoi + 1).Style = “Total”

bạn đổi lại tên cột A, H tùy theo thực tế nhé.

Đặng Huỳnh Hoàng Đinh

Đặng Huỳnh Hoàng Đinh 31 Dec 2022

Đặng Huỳnh Hoàng Đinh

Đặng Huỳnh Hoàng Đinh 31 Dec 2022

Module e viết lại 

Sub NhapDuLieu()
'Thu muc chon file
With Application.FileDialog(msoFileDialogFilePicker)
.AllowMultiSelect = True    'Chon nhieu file
.Show         'Hien cua so chon file


Dim i As Integer
For i = 1 To .SelectedItems.Count

'Gan bien cho wb
Dim wb_KQ As Workbook
Dim wb_CT As Workbook
Set wb_KQ = ThisWokbook
Set wb_CT = Workbooks.Open(.SelectedItems(i))

'DongDau_DongCuoi file Nhap
Dim DongDau_Nhap As Long
DongDau_Nhap = 8

Dim DongCuoi_Nhap As Long
DongCuoi_Nhap = wb_CT.Sheets(1).Range("A" & Rows.Count).End(xlUp).Row

'Khoang cach
Dim KhoangCach As Long
KhoangCach = DongCuoi_Nhap - DongDau_Nhap + 1

'DongCuoi file TongHop

Dim DongCuoi_Tong As Long
DongCuoi_Tong = wb_KQ.Sheets("Data_TienLuong").Range("A" & Rows.Count).End(xlUp).Row

'Copy du lieu
wb_KQ.Sheets("Data_TienLuong").Range("A" & DongCuoi_Tong + 1 & ":BM" & DongCuoi_Tong + KhoangCach).Value = _
wb_CT.Sheets(1).Range("A" & DongDau_Nhap & ":BM" & DongCuoi_Nhap).Value


'Dong NoiDung file
wb_CT.Close Savechanges:=False
Next i
End With

End Sub

{"id":74845,"crm_contact_id":53166,"name":"Tu\u1ea5n Ba","email":"laptrinhcchoexcel@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"b4a1dffcd4f5224a3e4df7e7ee0541d5","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-10-02T02:09:45.000000Z","updated_at":"2023-01-27T13:53:20.000000Z","deleted_at":null,"unit_name":"Gitiho","grade":0,"avatar_disk":"public","avatar_path":"users\/1637917341.jpg","gender":0,"birthday":"1992-03-19 00:00:00","position":"Ph\u00e1t tri\u1ec3n \u1ee9ng d\u1ee5ng C# cho Excel","achievement":"<p><br><\/p>","full_name":"L\u01b0\u01a1ng Tu\u00e2\u0301n Ba","address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","status_text":"<p>L\u00e0 T\u00e1c gi\u1ea3 c\u1ee7a Add- Ins Gitiho tools cho ph\u00e9p truy v\u1ea5n d\u1eef li\u1ec7u trong Excel v\u00e0 Access v\u00e0 tr\u1ea3 ra m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u1ed9ng.<\/p>","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":1,"primary_wallet":1010070,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":"118095757772556445137","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1927,"email_invalid":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_number":"2022-03-19","contract_date":"2022-03-18T17:00:00.000000Z","contract_delegate":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","contract_account_number":"19034644336010","contract_bank":"Techcombank","source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1637917341.jpg","link_profile":"https:\/\/gitiho.com\/teacher\/74845-tuan-ba","business_employers":[{"id":12,"biz_business_id":1,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","bizUser":"","avgCompleted":31.87}],"vip_account":null,"roles":[{"id":8,"name":"Teacher","display_name":"Teacher","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":8,"model_type":"App\\Models\\User"}},{"id":13,"name":"ContentManager","display_name":"Qu\u1ea3n l\u00fd n\u1ed9i dung","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-12-21T08:27:44.000000Z","pivot":{"model_id":74845,"role_id":13,"model_type":"App\\Models\\User"}},{"id":19,"name":"GitihoHumanResources","display_name":"GitihoHumanResources","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":19,"model_type":"App\\Models\\User"}}]}

Tuấn Ba [Chuyên gia] 03 Jan 2023

Bạn phải vào view chọn như hình

{"id":251122,"crm_contact_id":438548,"name":"dieuanh199952@gmail.com","email":"dieuanh199952@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2022-10-17 15:37:00","confirmation_code":"d59c90903d9e55582829c1a663b7ecde","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2022-10-04T07:26:19.000000Z","updated_at":"2023-01-13T09:20:20.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":2,"birthday":null,"position":null,"achievement":null,"full_name":"dieuanh199952@gmail.com","address":null,"status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":29449,"google_id":"117127447706941968677","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1,"email_invalid":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/images\/avatar\/folder_251\/dieuanh199952-at-gmailcom-dieuanh199952-at-gmailcom.png","link_profile":"https:\/\/gitiho.com\/u\/251122-dieuanh199952-at-gmailcom","business_employers":[],"vip_account":null,"roles":[]}

dieuanh199952@gmail.com 10 Jan 2023

mình thấy bạn viết từ workbook bị sai ấy

{"id":74845,"crm_contact_id":53166,"name":"Tu\u1ea5n Ba","email":"laptrinhcchoexcel@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"b4a1dffcd4f5224a3e4df7e7ee0541d5","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-10-02T02:09:45.000000Z","updated_at":"2023-01-27T13:53:20.000000Z","deleted_at":null,"unit_name":"Gitiho","grade":0,"avatar_disk":"public","avatar_path":"users\/1637917341.jpg","gender":0,"birthday":"1992-03-19 00:00:00","position":"Ph\u00e1t tri\u1ec3n \u1ee9ng d\u1ee5ng C# cho Excel","achievement":"<p><br><\/p>","full_name":"L\u01b0\u01a1ng Tu\u00e2\u0301n Ba","address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","status_text":"<p>L\u00e0 T\u00e1c gi\u1ea3 c\u1ee7a Add- Ins Gitiho tools cho ph\u00e9p truy v\u1ea5n d\u1eef li\u1ec7u trong Excel v\u00e0 Access v\u00e0 tr\u1ea3 ra m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u1ed9ng.<\/p>","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":1,"primary_wallet":1010070,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":"118095757772556445137","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1927,"email_invalid":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_number":"2022-03-19","contract_date":"2022-03-18T17:00:00.000000Z","contract_delegate":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","contract_account_number":"19034644336010","contract_bank":"Techcombank","source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1637917341.jpg","link_profile":"https:\/\/gitiho.com\/teacher\/74845-tuan-ba","business_employers":[{"id":12,"biz_business_id":1,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","bizUser":"","avgCompleted":31.87}],"vip_account":null,"roles":[{"id":8,"name":"Teacher","display_name":"Teacher","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":8,"model_type":"App\\Models\\User"}},{"id":13,"name":"ContentManager","display_name":"Qu\u1ea3n l\u00fd n\u1ed9i dung","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-12-21T08:27:44.000000Z","pivot":{"model_id":74845,"role_id":13,"model_type":"App\\Models\\User"}},{"id":19,"name":"GitihoHumanResources","display_name":"GitihoHumanResources","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":19,"model_type":"App\\Models\\User"}}]}

Tuấn Ba [Chuyên gia] 11 Jan 2023

bạn có thể xem file code tại đây

https://drive.google.com/file/d/1ZfKQQa91N-mIoUsupoiT3ibxjDNAzerv/view?usp=sharing

nguyễn văn khánh

nguyễn văn khánh 10 Jan 2023

Em làm giống trong bài giảng nhưng vẫn không mơr được flie chứa macro ạ

Dương Mạnh Quân

Dương Mạnh Quân [Chuyên gia] 10 Jan 2023

Không rõ bạn có thấy dòng thông báo nào màu hồng nào không (gần vị trí thông báo màu vàng về macro)?

Nếu có bạn cần đặt unblock cho file thì mới sử dụng được nhé. Bạn tham khảo video hướng dẫn này:

https://www.youtube.com/watch?v=B7PGvAD_IFU&t=1s

dieuanh199952@gmail.com

dieuanh199952@gmail.com 09 Jan 2023

Thầy có thể kiểm tra hộ em đoạn code này được ko ạ?

Sub GanBien_Book1()
Workbooks("Book4").Sheets("Data").Range("A2:C4").Value = _
Workbooks("Book1").Sheets("Sheet1").Range("A2:C4").Value

Dim DongCuoi_Wb2 As Long
DongCuoi_Wb2 = Workbooks("Book2").Sheets("Sheet1").Range("A" & Rows.Count).End(xlUp).Row


Dim DongDau_Wb2 As Long
DongDau_Wb2 = 2
Dim KhoangCach_Wb2 As Long
KhoangCach_Wb2 = DongCuoi_Wb2 - DongDau_Wb2 + 1

Dim DongCuoi_Wb4 As Long
DongCuoi_Wb4 = Workbooks("Book4").Sheets("Data").Range("A" & Rows.Count) _
.End(xlUp).Row
Workbooks("Book4").Sheets("Data").Range("A" & DongCuoi_Wb4 + 1 & ":C" & KhoangCach_Wb2).Value = _
Workbooks("Book2").Sheets("Sheet1").Range("A" & DongDau_Wb2 & ":C" & DongCuoi_Wb2).Value

 

End Sub
 

Em làm nó cứ bị ra value và ko gán được dữ liệu vào cùng một workbook ạ

Tuấn Ba

Tuấn Ba [Chuyên gia] 09 Jan 2023

Bạn xem 2 workbook có đang mở không?

 

{"id":66,"crm_contact_id":127658,"name":"D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n","email":"duongquan211287@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2018-11-06 21:53:37","confirmation_code":"d79b40591d95db0a31320b960a8a115c","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2017-05-10T03:17:27.000000Z","updated_at":"2023-01-28T00:56:40.000000Z","deleted_at":null,"unit_name":"Gitiho.com","grade":0,"avatar_disk":"public","avatar_path":"users\/1657593507.jpg","gender":0,"birthday":"1987-12-20 07:00:00","position":"Chuy\u00ean gia excel","achievement":null,"full_name":"D\u01b0\u01a1ng Qu\u00e2n","address":"Gitiho.com","status_text":"<p>Gi\u1ea3ng vi\u00ean: D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n<\/p><p>- N\u01a1i c\u00f4ng t\u00e1c hi\u1ec7n t\u1ea1i: Chuy\u00ean gia gi\u00e1o d\u1ee5c t\u1ea1i Gitiho.com<\/p><p><span style=\"color: rgb(0, 0, 0);\">- T\u1eebng l\u00e0m k\u1ebf to\u00e1n qu\u1ea3n tr\u1ecb t\u1ea1i c\u00f4ng ty TNHH DTK'Vina, tr\u1ef1c thu\u1ed9c t\u1eadp&nbsp;\u0111o\u00e0n DEAHO, H\u00e0n Qu\u1ed1c.<\/span><br><\/p><p>- H\u01a1n 7 n\u0103m kinh nghi\u1ec7m l\u00e0m vi\u1ec7c v\u1edbi&nbsp;excel trong l\u0129nh v\u1ef1c k\u1ebf to\u00e1n, t\u00e0i ch\u00ednh<\/p><p>- X\u00e2y d\u1ef1ng nhi\u1ec1u ph\u1ea7n m\u1ec1m&nbsp;excel trong c\u00e1c l\u0129nh v\u1ef1c: K\u1ebf to\u00e1n kho, k\u1ebf to\u00e1n c\u00f4ng n\u1ee3, k\u1ebf to\u00e1n ti\u1ec1n l\u01b0\u01a1ng... trong nhi\u1ec1u lo\u1ea1i h\u00ecnh doanh nghi\u1ec7p kh\u00e1c nhau.<\/p><p>- X\u00e2y d\u1ef1ng ph\u1ea7n m\u1ec1m&nbsp;excel trong l\u0129nh v\u1ef1c t\u00e0i ch\u00ednh: l\u1eadp ph\u01b0\u01a1ng&nbsp;\u00e1n kinh doanh, qu\u1ea3n tr\u1ecb d\u00f2ng ti\u1ec1n trong doanh nghi\u1ec7p...<\/p><p>- T\u01b0 v\u1ea5n gi\u1ea3i ph\u00e1p ho\u00e0n thi\u1ec7n quy tr\u00ecnh qu\u1ea3n l\u00fd doanh nghi\u1ec7p,&nbsp;\u00e1p d\u1ee5ng ph\u1ea7n m\u1ec1m&nbsp;excel n\u00e2ng cao hi\u1ec7u su\u1ea5t l\u00e0m vi\u1ec7c.<\/p><p><br><\/p>","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0977705162","become_teacher":0,"primary_wallet":54153591,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":"103589301897268320461","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1442,"email_invalid":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":"D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n","contract_number":"2022\/GITIHO-DUONGQUAN","contract_date":"2019-12-31T17:00:00.000000Z","contract_delegate":"D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n","contract_address":"24 ng\u00e1ch 9 ng\u00f5 162A T\u00f4n \u0110\u1ee9c Th\u1eafng, \u0110\u1ed1ng \u0110a, H\u00e0 N\u1ed9i","contract_account_number":"19033577541015","contract_bank":"Techcombank","source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1657593507.jpg","link_profile":"https:\/\/gitiho.com\/teacher\/66-duong-manh-quan","business_employers":[{"id":33,"biz_business_id":1,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","bizUser":"","avgCompleted":8.83}],"vip_account":null,"roles":[{"id":8,"name":"Teacher","display_name":"Teacher","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":66,"role_id":8,"model_type":"App\\Models\\User"}},{"id":15,"name":"BlogManager","display_name":"BlogManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":66,"role_id":15,"model_type":"App\\Models\\User"}},{"id":17,"name":"partnerAffiliate","display_name":"partnerAffiliate","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":66,"role_id":17,"model_type":"App\\Models\\User"}},{"id":19,"name":"GitihoHumanResources","display_name":"GitihoHumanResources","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":66,"role_id":19,"model_type":"App\\Models\\User"}}]}

Dương Mạnh Quân [Chuyên gia] 10 Jan 2023

Bời vì viết tên wokbook ở dạng Book2, Book4 nhưng có thể workbook của bạn có kèm theo cả đuôi file là .xlsx hoặc .xlsm. Bạn cần viết đủ tên và đuôi file nhé (khi file mới tạo thì chưa có đuôi file, nhưng khi lưu sẽ có dẫn tới code sẽ bị sai).

Thực ra cách viết này về sau sẽ thay đổi để viết tổng quát hơn, nên nội dung này chỉ cần bạn biết cách xác định vùng cho-nhận giữa 2 workbook là được.

Biện Văn Thành

Biện Văn Thành 08 Jan 2023

Thầy ơi? Sao tìm không thấy file excel bài giảng như trong video đề cập tới ạ? Muốn tải thì tải ở đâu ạ?

Tuấn Ba

Tuấn Ba [Chuyên gia] 08 Jan 2023

Bạn tải ở chương 1 bài 4 bạn nhé.

Thảo Vy

Thảo Vy 27 Dec 2022

tất cả file VBA em tải ở gitiho nhưng báo lỗi vậy ạ. Mong giảng viên hỗ trợ giúp em ạ

Tuấn Ba

Tuấn Ba [Chuyên gia] 28 Dec 2022

Bạn liên hệ cskh để được hỗ trợ nhé.

Hotline: 0774 116 285

{"id":66,"crm_contact_id":127658,"name":"D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n","email":"duongquan211287@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2018-11-06 21:53:37","confirmation_code":"d79b40591d95db0a31320b960a8a115c","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2017-05-10T03:17:27.000000Z","updated_at":"2023-01-28T00:56:40.000000Z","deleted_at":null,"unit_name":"Gitiho.com","grade":0,"avatar_disk":"public","avatar_path":"users\/1657593507.jpg","gender":0,"birthday":"1987-12-20 07:00:00","position":"Chuy\u00ean gia excel","achievement":null,"full_name":"D\u01b0\u01a1ng Qu\u00e2n","address":"Gitiho.com","status_text":"<p>Gi\u1ea3ng vi\u00ean: D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n<\/p><p>- N\u01a1i c\u00f4ng t\u00e1c hi\u1ec7n t\u1ea1i: Chuy\u00ean gia gi\u00e1o d\u1ee5c t\u1ea1i Gitiho.com<\/p><p><span style=\"color: rgb(0, 0, 0);\">- T\u1eebng l\u00e0m k\u1ebf to\u00e1n qu\u1ea3n tr\u1ecb t\u1ea1i c\u00f4ng ty TNHH DTK'Vina, tr\u1ef1c thu\u1ed9c t\u1eadp&nbsp;\u0111o\u00e0n DEAHO, H\u00e0n Qu\u1ed1c.<\/span><br><\/p><p>- H\u01a1n 7 n\u0103m kinh nghi\u1ec7m l\u00e0m vi\u1ec7c v\u1edbi&nbsp;excel trong l\u0129nh v\u1ef1c k\u1ebf to\u00e1n, t\u00e0i ch\u00ednh<\/p><p>- X\u00e2y d\u1ef1ng nhi\u1ec1u ph\u1ea7n m\u1ec1m&nbsp;excel trong c\u00e1c l\u0129nh v\u1ef1c: K\u1ebf to\u00e1n kho, k\u1ebf to\u00e1n c\u00f4ng n\u1ee3, k\u1ebf to\u00e1n ti\u1ec1n l\u01b0\u01a1ng... trong nhi\u1ec1u lo\u1ea1i h\u00ecnh doanh nghi\u1ec7p kh\u00e1c nhau.<\/p><p>- X\u00e2y d\u1ef1ng ph\u1ea7n m\u1ec1m&nbsp;excel trong l\u0129nh v\u1ef1c t\u00e0i ch\u00ednh: l\u1eadp ph\u01b0\u01a1ng&nbsp;\u00e1n kinh doanh, qu\u1ea3n tr\u1ecb d\u00f2ng ti\u1ec1n trong doanh nghi\u1ec7p...<\/p><p>- T\u01b0 v\u1ea5n gi\u1ea3i ph\u00e1p ho\u00e0n thi\u1ec7n quy tr\u00ecnh qu\u1ea3n l\u00fd doanh nghi\u1ec7p,&nbsp;\u00e1p d\u1ee5ng ph\u1ea7n m\u1ec1m&nbsp;excel n\u00e2ng cao hi\u1ec7u su\u1ea5t l\u00e0m vi\u1ec7c.<\/p><p><br><\/p>","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0977705162","become_teacher":0,"primary_wallet":54153591,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":"103589301897268320461","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1442,"email_invalid":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":"D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n","contract_number":"2022\/GITIHO-DUONGQUAN","contract_date":"2019-12-31T17:00:00.000000Z","contract_delegate":"D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n","contract_address":"24 ng\u00e1ch 9 ng\u00f5 162A T\u00f4n \u0110\u1ee9c Th\u1eafng, \u0110\u1ed1ng \u0110a, H\u00e0 N\u1ed9i","contract_account_number":"19033577541015","contract_bank":"Techcombank","source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1657593507.jpg","link_profile":"https:\/\/gitiho.com\/teacher\/66-duong-manh-quan","business_employers":[{"id":33,"biz_business_id":1,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","bizUser":"","avgCompleted":8.83}],"vip_account":null,"roles":[{"id":8,"name":"Teacher","display_name":"Teacher","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":66,"role_id":8,"model_type":"App\\Models\\User"}},{"id":15,"name":"BlogManager","display_name":"BlogManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":66,"role_id":15,"model_type":"App\\Models\\User"}},{"id":17,"name":"partnerAffiliate","display_name":"partnerAffiliate","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":66,"role_id":17,"model_type":"App\\Models\\User"}},{"id":19,"name":"GitihoHumanResources","display_name":"GitihoHumanResources","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":66,"role_id":19,"model_type":"App\\Models\\User"}}]}

Dương Mạnh Quân [Chuyên gia] 28 Dec 2022

Lỗi này là máy tính đang chưa cho phép sử dụng VBA. Bạn xem lại hướng dẫn trong chương 2 để biết cách khắc phục nhé.

{"id":228097,"crm_contact_id":355793,"name":"Th\u1ea3o Vy","email":"thaovy3011999@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2022-10-25 20:01:48","confirmation_code":"21f2c4b89c89425ff2aa8033f4f87cb9","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2022-06-10T08:57:12.000000Z","updated_at":"2023-01-22T08:10:23.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"public","avatar_path":"users\/1671152698.jpg","gender":1,"birthday":"1999-11-30 00:00:00","position":null,"achievement":null,"full_name":"L\u00ea Ng\u1ecdc Th\u1ea3o Vy","address":"B\u00ecnh Ch\u00e1nh, H\u1ed3 Ch\u00ed Minh","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0775199121","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":103390,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1,"email_invalid":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1671152698.jpg","link_profile":"https:\/\/gitiho.com\/u\/228097-thao-vy","business_employers":[],"vip_account":{"id":2590,"user_id":228097,"vip_account_id":1,"sale_price":291623,"discount":50,"time_start":"2022-12-16 14:34:52","time_end":"2023-12-16 14:34:52","created_at":"2022-12-16T07:34:52.000000Z","updated_at":"2022-12-16T07:34:52.000000Z"},"roles":[]}

Thảo Vy 02 Jan 2023

em có xem và làm như vẫn báo như vậy ạ

{"id":66,"crm_contact_id":127658,"name":"D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n","email":"duongquan211287@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2018-11-06 21:53:37","confirmation_code":"d79b40591d95db0a31320b960a8a115c","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2017-05-10T03:17:27.000000Z","updated_at":"2023-01-28T00:56:40.000000Z","deleted_at":null,"unit_name":"Gitiho.com","grade":0,"avatar_disk":"public","avatar_path":"users\/1657593507.jpg","gender":0,"birthday":"1987-12-20 07:00:00","position":"Chuy\u00ean gia excel","achievement":null,"full_name":"D\u01b0\u01a1ng Qu\u00e2n","address":"Gitiho.com","status_text":"<p>Gi\u1ea3ng vi\u00ean: D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n<\/p><p>- N\u01a1i c\u00f4ng t\u00e1c hi\u1ec7n t\u1ea1i: Chuy\u00ean gia gi\u00e1o d\u1ee5c t\u1ea1i Gitiho.com<\/p><p><span style=\"color: rgb(0, 0, 0);\">- T\u1eebng l\u00e0m k\u1ebf to\u00e1n qu\u1ea3n tr\u1ecb t\u1ea1i c\u00f4ng ty TNHH DTK'Vina, tr\u1ef1c thu\u1ed9c t\u1eadp&nbsp;\u0111o\u00e0n DEAHO, H\u00e0n Qu\u1ed1c.<\/span><br><\/p><p>- H\u01a1n 7 n\u0103m kinh nghi\u1ec7m l\u00e0m vi\u1ec7c v\u1edbi&nbsp;excel trong l\u0129nh v\u1ef1c k\u1ebf to\u00e1n, t\u00e0i ch\u00ednh<\/p><p>- X\u00e2y d\u1ef1ng nhi\u1ec1u ph\u1ea7n m\u1ec1m&nbsp;excel trong c\u00e1c l\u0129nh v\u1ef1c: K\u1ebf to\u00e1n kho, k\u1ebf to\u00e1n c\u00f4ng n\u1ee3, k\u1ebf to\u00e1n ti\u1ec1n l\u01b0\u01a1ng... trong nhi\u1ec1u lo\u1ea1i h\u00ecnh doanh nghi\u1ec7p kh\u00e1c nhau.<\/p><p>- X\u00e2y d\u1ef1ng ph\u1ea7n m\u1ec1m&nbsp;excel trong l\u0129nh v\u1ef1c t\u00e0i ch\u00ednh: l\u1eadp ph\u01b0\u01a1ng&nbsp;\u00e1n kinh doanh, qu\u1ea3n tr\u1ecb d\u00f2ng ti\u1ec1n trong doanh nghi\u1ec7p...<\/p><p>- T\u01b0 v\u1ea5n gi\u1ea3i ph\u00e1p ho\u00e0n thi\u1ec7n quy tr\u00ecnh qu\u1ea3n l\u00fd doanh nghi\u1ec7p,&nbsp;\u00e1p d\u1ee5ng ph\u1ea7n m\u1ec1m&nbsp;excel n\u00e2ng cao hi\u1ec7u su\u1ea5t l\u00e0m vi\u1ec7c.<\/p><p><br><\/p>","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0977705162","become_teacher":0,"primary_wallet":54153591,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":"103589301897268320461","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1442,"email_invalid":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":"D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n","contract_number":"2022\/GITIHO-DUONGQUAN","contract_date":"2019-12-31T17:00:00.000000Z","contract_delegate":"D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n","contract_address":"24 ng\u00e1ch 9 ng\u00f5 162A T\u00f4n \u0110\u1ee9c Th\u1eafng, \u0110\u1ed1ng \u0110a, H\u00e0 N\u1ed9i","contract_account_number":"19033577541015","contract_bank":"Techcombank","source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1657593507.jpg","link_profile":"https:\/\/gitiho.com\/teacher\/66-duong-manh-quan","business_employers":[{"id":33,"biz_business_id":1,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","bizUser":"","avgCompleted":8.83}],"vip_account":null,"roles":[{"id":8,"name":"Teacher","display_name":"Teacher","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":66,"role_id":8,"model_type":"App\\Models\\User"}},{"id":15,"name":"BlogManager","display_name":"BlogManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":66,"role_id":15,"model_type":"App\\Models\\User"}},{"id":17,"name":"partnerAffiliate","display_name":"partnerAffiliate","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":66,"role_id":17,"model_type":"App\\Models\\User"}},{"id":19,"name":"GitihoHumanResources","display_name":"GitihoHumanResources","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":66,"role_id":19,"model_type":"App\\Models\\User"}}]}

Dương Mạnh Quân [Chuyên gia] 03 Jan 2023

Thế bạn liên hệ bộ phận CSKH để được hỗ trợ nhé. Vì mình chưa rõ nguyên nhân nào khác khiến bạn vẫn gặp lỗi này.

{"id":228097,"crm_contact_id":355793,"name":"Th\u1ea3o Vy","email":"thaovy3011999@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2022-10-25 20:01:48","confirmation_code":"21f2c4b89c89425ff2aa8033f4f87cb9","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2022-06-10T08:57:12.000000Z","updated_at":"2023-01-22T08:10:23.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"public","avatar_path":"users\/1671152698.jpg","gender":1,"birthday":"1999-11-30 00:00:00","position":null,"achievement":null,"full_name":"L\u00ea Ng\u1ecdc Th\u1ea3o Vy","address":"B\u00ecnh Ch\u00e1nh, H\u1ed3 Ch\u00ed Minh","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0775199121","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":103390,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1,"email_invalid":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1671152698.jpg","link_profile":"https:\/\/gitiho.com\/u\/228097-thao-vy","business_employers":[],"vip_account":{"id":2590,"user_id":228097,"vip_account_id":1,"sale_price":291623,"discount":50,"time_start":"2022-12-16 14:34:52","time_end":"2023-12-16 14:34:52","created_at":"2022-12-16T07:34:52.000000Z","updated_at":"2022-12-16T07:34:52.000000Z"},"roles":[]}

Thảo Vy 07 Jan 2023

file excel có chứa macro khi em bấm vào thì sẽ hiển thị thông báo như vậy. Em có vào phần cài đặt cho phép sử dụng macro (hình 2) nhưng vẫn không được ạ. 

{"id":74845,"crm_contact_id":53166,"name":"Tu\u1ea5n Ba","email":"laptrinhcchoexcel@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"b4a1dffcd4f5224a3e4df7e7ee0541d5","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-10-02T02:09:45.000000Z","updated_at":"2023-01-27T13:53:20.000000Z","deleted_at":null,"unit_name":"Gitiho","grade":0,"avatar_disk":"public","avatar_path":"users\/1637917341.jpg","gender":0,"birthday":"1992-03-19 00:00:00","position":"Ph\u00e1t tri\u1ec3n \u1ee9ng d\u1ee5ng C# cho Excel","achievement":"<p><br><\/p>","full_name":"L\u01b0\u01a1ng Tu\u00e2\u0301n Ba","address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","status_text":"<p>L\u00e0 T\u00e1c gi\u1ea3 c\u1ee7a Add- Ins Gitiho tools cho ph\u00e9p truy v\u1ea5n d\u1eef li\u1ec7u trong Excel v\u00e0 Access v\u00e0 tr\u1ea3 ra m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u1ed9ng.<\/p>","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":1,"primary_wallet":1010070,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":"118095757772556445137","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1927,"email_invalid":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_number":"2022-03-19","contract_date":"2022-03-18T17:00:00.000000Z","contract_delegate":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","contract_account_number":"19034644336010","contract_bank":"Techcombank","source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1637917341.jpg","link_profile":"https:\/\/gitiho.com\/teacher\/74845-tuan-ba","business_employers":[{"id":12,"biz_business_id":1,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","bizUser":"","avgCompleted":31.87}],"vip_account":null,"roles":[{"id":8,"name":"Teacher","display_name":"Teacher","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":8,"model_type":"App\\Models\\User"}},{"id":13,"name":"ContentManager","display_name":"Qu\u1ea3n l\u00fd n\u1ed9i dung","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-12-21T08:27:44.000000Z","pivot":{"model_id":74845,"role_id":13,"model_type":"App\\Models\\User"}},{"id":19,"name":"GitihoHumanResources","display_name":"GitihoHumanResources","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":19,"model_type":"App\\Models\\User"}}]}

Tuấn Ba [Chuyên gia] 08 Jan 2023

Bạn liên hệ cskh để được hỗ trợ nhé.

Trần Quốc Tiến

Trần Quốc Tiến 03 Jan 2023

Tuấn Ba

Tuấn Ba [Chuyên gia] 03 Jan 2023

Bạn đẩy file lên nhé.

{"id":245043,"crm_contact_id":426659,"name":"Tr\u1ea7n Qu\u1ed1c Ti\u1ebfn","email":"quoctientran1999@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"7483c9ca796feec7881c6901d54ecb63","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2022-09-08T03:19:27.000000Z","updated_at":"2023-01-02T17:38:42.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":2,"birthday":null,"position":null,"achievement":null,"full_name":null,"address":"520\/8 X\u00f4 Vi\u1ebft Ngh\u1ec7 T\u0129nh ph\u01b0\u1eddng 25 qu\u1eadn B\u00ecnh Th\u1ea1nh","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0385553027","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":40072,"google_id":"109708021437137521750","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_invalid":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/images\/avatar\/folder_245\/tran-tien.png","link_profile":"https:\/\/gitiho.com\/u\/245043-tran-quoc-tien","business_employers":[],"vip_account":null,"roles":[]}

Trần Quốc Tiến 05 Jan 2023

em gửi thầy

 

{"id":66,"crm_contact_id":127658,"name":"D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n","email":"duongquan211287@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2018-11-06 21:53:37","confirmation_code":"d79b40591d95db0a31320b960a8a115c","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2017-05-10T03:17:27.000000Z","updated_at":"2023-01-28T00:56:40.000000Z","deleted_at":null,"unit_name":"Gitiho.com","grade":0,"avatar_disk":"public","avatar_path":"users\/1657593507.jpg","gender":0,"birthday":"1987-12-20 07:00:00","position":"Chuy\u00ean gia excel","achievement":null,"full_name":"D\u01b0\u01a1ng Qu\u00e2n","address":"Gitiho.com","status_text":"<p>Gi\u1ea3ng vi\u00ean: D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n<\/p><p>- N\u01a1i c\u00f4ng t\u00e1c hi\u1ec7n t\u1ea1i: Chuy\u00ean gia gi\u00e1o d\u1ee5c t\u1ea1i Gitiho.com<\/p><p><span style=\"color: rgb(0, 0, 0);\">- T\u1eebng l\u00e0m k\u1ebf to\u00e1n qu\u1ea3n tr\u1ecb t\u1ea1i c\u00f4ng ty TNHH DTK'Vina, tr\u1ef1c thu\u1ed9c t\u1eadp&nbsp;\u0111o\u00e0n DEAHO, H\u00e0n Qu\u1ed1c.<\/span><br><\/p><p>- H\u01a1n 7 n\u0103m kinh nghi\u1ec7m l\u00e0m vi\u1ec7c v\u1edbi&nbsp;excel trong l\u0129nh v\u1ef1c k\u1ebf to\u00e1n, t\u00e0i ch\u00ednh<\/p><p>- X\u00e2y d\u1ef1ng nhi\u1ec1u ph\u1ea7n m\u1ec1m&nbsp;excel trong c\u00e1c l\u0129nh v\u1ef1c: K\u1ebf to\u00e1n kho, k\u1ebf to\u00e1n c\u00f4ng n\u1ee3, k\u1ebf to\u00e1n ti\u1ec1n l\u01b0\u01a1ng... trong nhi\u1ec1u lo\u1ea1i h\u00ecnh doanh nghi\u1ec7p kh\u00e1c nhau.<\/p><p>- X\u00e2y d\u1ef1ng ph\u1ea7n m\u1ec1m&nbsp;excel trong l\u0129nh v\u1ef1c t\u00e0i ch\u00ednh: l\u1eadp ph\u01b0\u01a1ng&nbsp;\u00e1n kinh doanh, qu\u1ea3n tr\u1ecb d\u00f2ng ti\u1ec1n trong doanh nghi\u1ec7p...<\/p><p>- T\u01b0 v\u1ea5n gi\u1ea3i ph\u00e1p ho\u00e0n thi\u1ec7n quy tr\u00ecnh qu\u1ea3n l\u00fd doanh nghi\u1ec7p,&nbsp;\u00e1p d\u1ee5ng ph\u1ea7n m\u1ec1m&nbsp;excel n\u00e2ng cao hi\u1ec7u su\u1ea5t l\u00e0m vi\u1ec7c.<\/p><p><br><\/p>","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0977705162","become_teacher":0,"primary_wallet":54153591,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":"103589301897268320461","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1442,"email_invalid":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":"D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n","contract_number":"2022\/GITIHO-DUONGQUAN","contract_date":"2019-12-31T17:00:00.000000Z","contract_delegate":"D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n","contract_address":"24 ng\u00e1ch 9 ng\u00f5 162A T\u00f4n \u0110\u1ee9c Th\u1eafng, \u0110\u1ed1ng \u0110a, H\u00e0 N\u1ed9i","contract_account_number":"19033577541015","contract_bank":"Techcombank","source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1657593507.jpg","link_profile":"https:\/\/gitiho.com\/teacher\/66-duong-manh-quan","business_employers":[{"id":33,"biz_business_id":1,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","bizUser":"","avgCompleted":8.83}],"vip_account":null,"roles":[{"id":8,"name":"Teacher","display_name":"Teacher","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":66,"role_id":8,"model_type":"App\\Models\\User"}},{"id":15,"name":"BlogManager","display_name":"BlogManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":66,"role_id":15,"model_type":"App\\Models\\User"}},{"id":17,"name":"partnerAffiliate","display_name":"partnerAffiliate","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":66,"role_id":17,"model_type":"App\\Models\\User"}},{"id":19,"name":"GitihoHumanResources","display_name":"GitihoHumanResources","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":66,"role_id":19,"model_type":"App\\Models\\User"}}]}

Dương Mạnh Quân [Chuyên gia] 05 Jan 2023

Lỗi này do cách viết code: khi viết rõ workbook thì đối tượng worksheet phải viết theo Name hoặc số thứ tự sheet, không được viết dạng Sheet1 (code-name).

Bạn sửa lại phần Sheet này nhé.

{"id":245043,"crm_contact_id":426659,"name":"Tr\u1ea7n Qu\u1ed1c Ti\u1ebfn","email":"quoctientran1999@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"7483c9ca796feec7881c6901d54ecb63","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2022-09-08T03:19:27.000000Z","updated_at":"2023-01-02T17:38:42.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":2,"birthday":null,"position":null,"achievement":null,"full_name":null,"address":"520\/8 X\u00f4 Vi\u1ebft Ngh\u1ec7 T\u0129nh ph\u01b0\u1eddng 25 qu\u1eadn B\u00ecnh Th\u1ea1nh","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0385553027","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":40072,"google_id":"109708021437137521750","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_invalid":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/images\/avatar\/folder_245\/tran-tien.png","link_profile":"https:\/\/gitiho.com\/u\/245043-tran-quoc-tien","business_employers":[],"vip_account":null,"roles":[]}

Trần Quốc Tiến 06 Jan 2023

{"id":245043,"crm_contact_id":426659,"name":"Tr\u1ea7n Qu\u1ed1c Ti\u1ebfn","email":"quoctientran1999@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"7483c9ca796feec7881c6901d54ecb63","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2022-09-08T03:19:27.000000Z","updated_at":"2023-01-02T17:38:42.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":2,"birthday":null,"position":null,"achievement":null,"full_name":null,"address":"520\/8 X\u00f4 Vi\u1ebft Ngh\u1ec7 T\u0129nh ph\u01b0\u1eddng 25 qu\u1eadn B\u00ecnh Th\u1ea1nh","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0385553027","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":40072,"google_id":"109708021437137521750","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_invalid":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/images\/avatar\/folder_245\/tran-tien.png","link_profile":"https:\/\/gitiho.com\/u\/245043-tran-quoc-tien","business_employers":[],"vip_account":null,"roles":[]}

Trần Quốc Tiến 06 Jan 2023

em đã đổi lại nhưng vẫn chưa được ạ

 

Nguyễn Tá Hiến

Nguyễn Tá Hiến 05 Jan 2023

Sub locgiatri_3()

Dim i As Long, j As Long, dc As Long
  With Sheet1
  dc = Sheet1.Range("g65000").End(xlUp).Row
   .Range("k10:k10000").ClearContents
     For j = 100 To dc
       For i = 1 To 99
        If .Range("g" & i).Value = Range("g" & j).Value Then
          .Range("k" & j).Value = 1
            Exit For
            Else
          .Range("k" & j).Value = 0
         End If
        Next
      Next
    End With
 End Sub
 

Tuấn Ba

Tuấn Ba [Chuyên gia] 05 Jan 2023

Chào bạn bạn đẩy cả file lên để gitiho check nữa nhé.

{"id":93245,"crm_contact_id":13735,"name":"Nguy\u00ea\u0303n Ta\u0301 Hi\u00ea\u0301n","email":"tahien14041974@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2022-04-30 17:44:35","confirmation_code":"20edf6d434a1a0d1f356fab5b218c251","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2020-06-03T04:39:44.000000Z","updated_at":"2022-12-31T08:27:41.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":0,"birthday":null,"position":null,"achievement":null,"full_name":"Nguy\u00ea\u0303n Ta\u0301 Hi\u00ea\u0301n","address":"\u0110\u1ed9i 12, th\u00f4n ng\u1ecdc l\u00e2m, x\u00e3 t\u00e2n k\u00ec, t\u1ee9 k\u00ec, h\u1ea3i d\u01b0\u01a1ng","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0359465026","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":51453,"google_id":"116449262594280212780","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1,"email_invalid":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/images\/avatar\/folder_93\/nguyen-hien.png","link_profile":"https:\/\/gitiho.com\/u\/93245-nguyen-ta-hien","business_employers":[],"vip_account":null,"roles":[]}

Nguyễn Tá Hiến 05 Jan 2023

em gui fite thay xem hô em voi a

{"id":66,"crm_contact_id":127658,"name":"D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n","email":"duongquan211287@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2018-11-06 21:53:37","confirmation_code":"d79b40591d95db0a31320b960a8a115c","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2017-05-10T03:17:27.000000Z","updated_at":"2023-01-28T00:56:40.000000Z","deleted_at":null,"unit_name":"Gitiho.com","grade":0,"avatar_disk":"public","avatar_path":"users\/1657593507.jpg","gender":0,"birthday":"1987-12-20 07:00:00","position":"Chuy\u00ean gia excel","achievement":null,"full_name":"D\u01b0\u01a1ng Qu\u00e2n","address":"Gitiho.com","status_text":"<p>Gi\u1ea3ng vi\u00ean: D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n<\/p><p>- N\u01a1i c\u00f4ng t\u00e1c hi\u1ec7n t\u1ea1i: Chuy\u00ean gia gi\u00e1o d\u1ee5c t\u1ea1i Gitiho.com<\/p><p><span style=\"color: rgb(0, 0, 0);\">- T\u1eebng l\u00e0m k\u1ebf to\u00e1n qu\u1ea3n tr\u1ecb t\u1ea1i c\u00f4ng ty TNHH DTK'Vina, tr\u1ef1c thu\u1ed9c t\u1eadp&nbsp;\u0111o\u00e0n DEAHO, H\u00e0n Qu\u1ed1c.<\/span><br><\/p><p>- H\u01a1n 7 n\u0103m kinh nghi\u1ec7m l\u00e0m vi\u1ec7c v\u1edbi&nbsp;excel trong l\u0129nh v\u1ef1c k\u1ebf to\u00e1n, t\u00e0i ch\u00ednh<\/p><p>- X\u00e2y d\u1ef1ng nhi\u1ec1u ph\u1ea7n m\u1ec1m&nbsp;excel trong c\u00e1c l\u0129nh v\u1ef1c: K\u1ebf to\u00e1n kho, k\u1ebf to\u00e1n c\u00f4ng n\u1ee3, k\u1ebf to\u00e1n ti\u1ec1n l\u01b0\u01a1ng... trong nhi\u1ec1u lo\u1ea1i h\u00ecnh doanh nghi\u1ec7p kh\u00e1c nhau.<\/p><p>- X\u00e2y d\u1ef1ng ph\u1ea7n m\u1ec1m&nbsp;excel trong l\u0129nh v\u1ef1c t\u00e0i ch\u00ednh: l\u1eadp ph\u01b0\u01a1ng&nbsp;\u00e1n kinh doanh, qu\u1ea3n tr\u1ecb d\u00f2ng ti\u1ec1n trong doanh nghi\u1ec7p...<\/p><p>- T\u01b0 v\u1ea5n gi\u1ea3i ph\u00e1p ho\u00e0n thi\u1ec7n quy tr\u00ecnh qu\u1ea3n l\u00fd doanh nghi\u1ec7p,&nbsp;\u00e1p d\u1ee5ng ph\u1ea7n m\u1ec1m&nbsp;excel n\u00e2ng cao hi\u1ec7u su\u1ea5t l\u00e0m vi\u1ec7c.<\/p><p><br><\/p>","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0977705162","become_teacher":0,"primary_wallet":54153591,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":"103589301897268320461","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1442,"email_invalid":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":"D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n","contract_number":"2022\/GITIHO-DUONGQUAN","contract_date":"2019-12-31T17:00:00.000000Z","contract_delegate":"D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n","contract_address":"24 ng\u00e1ch 9 ng\u00f5 162A T\u00f4n \u0110\u1ee9c Th\u1eafng, \u0110\u1ed1ng \u0110a, H\u00e0 N\u1ed9i","contract_account_number":"19033577541015","contract_bank":"Techcombank","source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1657593507.jpg","link_profile":"https:\/\/gitiho.com\/teacher\/66-duong-manh-quan","business_employers":[{"id":33,"biz_business_id":1,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","bizUser":"","avgCompleted":8.83}],"vip_account":null,"roles":[{"id":8,"name":"Teacher","display_name":"Teacher","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":66,"role_id":8,"model_type":"App\\Models\\User"}},{"id":15,"name":"BlogManager","display_name":"BlogManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":66,"role_id":15,"model_type":"App\\Models\\User"}},{"id":17,"name":"partnerAffiliate","display_name":"partnerAffiliate","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":66,"role_id":17,"model_type":"App\\Models\\User"}},{"id":19,"name":"GitihoHumanResources","display_name":"GitihoHumanResources","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":66,"role_id":19,"model_type":"App\\Models\\User"}}]}

Dương Mạnh Quân [Chuyên gia] 05 Jan 2023

Nếu vẫn là vòng lặp đó, chỉ thay đổi giá trị của biến thì bạn có thể viết thành nhiều sub, mỗi sub chạy 1 vòng lặp. Sau đó lần lượt gọi các sub là được.

Ví dụ: Sub_vongLap1 chạy vòng lặp từ 1 đến 99, Sub_vongLap2 chạy vòng lặp từ 2 đến 100…

Sau đó viết tổng quát dạng:

Sub TongQuat()

Call Sub_vongLap1

Call Sub_vongLap2

End sub

{"id":93245,"crm_contact_id":13735,"name":"Nguy\u00ea\u0303n Ta\u0301 Hi\u00ea\u0301n","email":"tahien14041974@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2022-04-30 17:44:35","confirmation_code":"20edf6d434a1a0d1f356fab5b218c251","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2020-06-03T04:39:44.000000Z","updated_at":"2022-12-31T08:27:41.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":0,"birthday":null,"position":null,"achievement":null,"full_name":"Nguy\u00ea\u0303n Ta\u0301 Hi\u00ea\u0301n","address":"\u0110\u1ed9i 12, th\u00f4n ng\u1ecdc l\u00e2m, x\u00e3 t\u00e2n k\u00ec, t\u1ee9 k\u00ec, h\u1ea3i d\u01b0\u01a1ng","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0359465026","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":51453,"google_id":"116449262594280212780","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1,"email_invalid":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/images\/avatar\/folder_93\/nguyen-hien.png","link_profile":"https:\/\/gitiho.com\/u\/93245-nguyen-ta-hien","business_employers":[],"vip_account":null,"roles":[]}

Nguyễn Tá Hiến 05 Jan 2023

thây ơi dữ liêu của em nó hàng vài nghin dòng cơ em muốn gôp lai chứ ko em đã viết như sub trên

VBAG01: Tuyệt đỉnh VBA - Viết code trong tầm tay
4.84

(64 đánh giá)

15,917 học viên
499,000đ
@ 2020 - Bản quyền của Công ty cổ phần công nghệ giáo dục Gitiho Việt Nam
Giấy chứng nhận Đăng ký doanh nghiệp số: 0109077145, cấp bởi Sở kế hoạch và đầu tư TP. Hà Nội
/