Copy and edit data in 1 file then put to another file

[Do Duy]

Hi everyone,

I need your valuable help. I need some pro in vbs help me to solve this problem.
STEP 1 It will copy data from cell R2(->R100) of CSV file
STEP 2 Paste data to cell G1 of excel file
STEP 3 Using Replace function as I has in Marco
STEP 4 Auto paste data from C1:C143 of sheet to C8 cell of "Summary" Sheet

Loop again for next row in CSV file into F8, G8,H8... cell of "Summary" Sheet

Sorry for my English is not good. Please look at excel file for more detail.

 

[Marc L]

Hi !

Not vbs but VBA «black art» here and you forgot to join a source csv text file !
Join also a worksheet result according to this csv file …
​

 

[Do Duy]

Hi Marc L

Thank for your quick reply, at this time I dont have CSV in my PC, but you can use my test data which I have put on my sample file

 

[Marc L]

From csv file, I can directly jump to STEP 4 !

If you prefer to follow the way of your initial post,
just activate Macro recorder and do each step : you will get a code base …

Edit : but it seems not to be a csv file ‼ As I have no much time, I quit !
​

 

[Do Duy]

Sorry Marc L,

I just upload both file again, please look at file and help me please.

 

[Do Duy]

Sorry Deepak, vletm

Can anyone help me in this case? Thank

 

[Deepak]

Sorry ...

Can anyone help me in this case? Thank

Don't tag anonymously. @Marc L will take care of the same.