Merging 2 excel files with different columns (user form to select files and column mapping needed)
Hi,
I need to merge two excel files into one with new column mapping - e.g. file one columns 1,3,5 to be located in columns 4,6,8 in output sheet.
As this will be done once a week, I also need to select files using a user form.
I have had a go so far and think I have come close, however it doesn't quite seem to work and I can't for the life of me figure out what's wrong with my VBA code.
The code is attached below:
Any help is MASSIVELY appreciated.
Thanks in advance,
Olivier
Attachment | Size |
---|---|
Code for merging files.txt | 7.19 KB |
Recent comments
5 years 36 weeks ago
6 years 22 weeks ago
6 years 34 weeks ago
6 years 37 weeks ago
6 years 38 weeks ago
6 years 43 weeks ago
6 years 52 weeks ago
7 years 2 days ago
7 years 3 days ago
7 years 3 days ago