PDA

View Full Version : Match columns linked to external workbook



jmaocubo
06-17-2010, 06:10 AM
Hi!

I'm trying to create a VBA code that allows me to import data from another excel file based on the header.

The master file header is fixed, but the file where I import is random and may contain more columns than necessary.
I needed a code:
1) to open the explorer;
2) let me select the right file to import data;
3) analyze the header;
4) import the data into the master in the right places.

the size of data file is also variable

Please see the attachment

Thanks in advance

Miguel

jmaocubo
06-22-2010, 04:34 AM
Anyone????