use file list to open files to copy cells over

[chi11]

hi guys, I have another question.

I have a macro that I am writing. What it does so far is that it lists the file path of a working folder that the user determines. What I need it to do is open each file, copy A2 and the last cell is column A and past A2 is the active G2 column and the last file in H2. Then I need it to move to the next file and do it again but this time move down to G3 and H3, still it finishes all of the files in folder. I will attach a .xls as an example and also here is my code;

Please Login or Register  to view this content.

[arlu1201]

Use this code -

Please Login or Register  to view this content.

[chi11]

thanks, it works great . Rep ++