Loop and copying data from different columns

[amartino44]

Hello. I've written code to open files and then copy data from those files into a master file. The first time I just wanted to copy data from the first two columns, but now I would like to copy data from columns A:B and D:E and I'm not sure how to adjust my code. If someone could help I would appreciate it (explanations with code would be helpful too) The "else" statement below is used because I only want to add headers from the first worksheet. Thanks.

Please Login or Register  to view this content.

[HaHoBe]

Hi, amartino44,

in your code you start copying over into a sheet starting at A1 but what will happen if you run this macro again? The first workbook copies to the range from A1 while the others are amended under the old data?

Code is untested but may look like this:

Please Login or Register  to view this content.

Ciao,
Holger