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
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