How to import data from one excel file and put it in the desired column in another excel file?

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

Hi @Famui_Yanisa ,
I think you want to write column C in file1 to column Animals (A1) in file2, column B to A-Z, and column A to Column Number(C1)
You can
-use excel read range file1
-filter data to get column what you need keep
-use write range to file2
My in/out

My code

regards,