Write data all month Excel file

[anh.nguyen]

Hello all,

I have Shift Schedule Excel file export from software and need to fill data into files monthly.

I read the file and filtered the department. How can I fill “VP1” from Mon-Sat ( excluding Saturday of the 2nd week: Mon-Fri)
Some staff members will be special by Code. Example: B00828 “HC1” from Mon-Sat

GA_PRO004_202308021341.xls (43 KB)

Thank all,

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

@anh.nguyen

Hello all,

I have Shift Schedule Excel file export from software and need to fill data into files monthly.

I read the file and filtered the department. How can I fill “VP1” from Mon-Sat ( excluding Saturday of the 2nd week: Mon-Fri)
Some staff members will be special by Code. Example: B00828 “HC1” from Mon-Sat

Hi @anh.nguyen ,
mình chưa hiểu ý lắm
với ghi theo chỉ mục cụ thể vậy write cell hoặc write range hoàn toàn làm được
với các mã special thì những mã nào
bạn có thể clear requirements, mình sẽ code
Regards,
LNV