It certainly wasn't clear from your post that you wanted to double the number of columns; the description could just as easily be met by adding a row and putting the new data on the row following the existing one.

The clarified description can certainly be met, but you need to provide more details about:
• how the macro should locate/identify the two source files;
• which file is to be regarded as holding the 'primary' table; and
• what is to happen where there a country differences between the two files (e.g. do the unmatched data from the 'secondary' table get written to the newly-added secondary columns or to the primary columns? Do empty secondary columns get added to the 'primary' data when there are no secondary data). Your 'no' description is by no means clear about that.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]