I want to use for each file in folder to read files in one folder and write to files in another folder

[leanhtuan221200 (Tuan)]

• Open the file “List of employees” in Folder: 02 DuLieu NhanSu
  and Copy data column B, A of the file
• Paste the values ​​in columns A, C sheet “NVCT” of the files “XuLyDuLieuAnCa_Xuong2” in Folder: 04_XuLyDuLieu
• Do the same for other files in Folder: 02_DuLieuNhanSu
• Image 1 is the files in folder 02_DuLieuNhanSu
  Image 2 is the files in folder 04_XuLyDuLieu

Danh sach nhan vien_Xuong 2.xlsx (84.9 KB)
XuLyDuLieuAnCa_Xuong2.xlsx (18.3 KB)

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

Hi @leanhtuan221200 ,
Only same number of “Xuong”
ex: danh sach nhan vien xuong 2 --xu ly du lieu an ca xuong 2

that’s right?

[leanhtuan221200 (Tuan)]

That’s right, and read danh sach nhan vien xuong 2 – write xu ly du lieu an ca xuong 2

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

OK. wait me some minutes
we need check file name only—> important
get data then paste is simple

[leanhtuan221200 (Tuan)]

I need help me, please

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

Hi @leanhtuan221200 ,
Sr reply late because I have online meeting with customer
my solution
you can try
Sequence.xaml (26.7 KB)
myinput

file download form you
my output

regards,
LNV