Hi, I am using the same code and have found it really useful reading through this so thanks. In my case however I am trying to select different columns for each of the 2 source files and can't for the life of me how to go about it as the looping function obviously uses the same column mapping.

I'm trying map the following sourcesheet columns TO output worksheet columns:
Sheet 1:
C TO A
D TO B
E TO C
I TO D

Sheet 2:
B TO F
J TO G
H TO H
C TO I

How can I adapt this code to allow for this? Any help is massively appreciated... I feel I am going around in circles at the moment :-(

Thanks,

Olivier