Import selected columns

Hi,

I'm working on some code for you, but just a few questions to clarify...

In the *Master* workbook, must the data collected from the source files be appended below the existing data, or must it replace it? IOW, if I import the data from source file 1 into master, then close file 1 and open source file 2, must the data of source file 2 be pasted in the appropriate columns BELOW source file 1's data, or must it be pasted onto a second sheet in Master...and so forth until all source files are imported?

Secondly, I can understand collecting the data from source files from columns(A, E, F, and I) and from rows 4 to the end of each column, but where must the two pieces of data from cells C3 and E3 go? Maybe E3 replaces the heading E3 in the Master, but where must C3 go since we are not importing column C data?

TX

Hi,

Here is some code based on what I think you might need. It appends the data from the source files below the last data in each of the columns in the first sheet of the *Master* file. Place the code below into a module in the Master file and run...

Please Login or Register  to view this content.

Hi,

If you want each Code sheet for the file to be added to a separate sheet in Master, the macro can add a sheet each time automatically for the file it is processing. I'll modify the macro to add a sheet for each Code sheet it processes...and update the C3 and E3 positions.

Try this code...

Please Login or Register  to view this content.

It's probably due to being a calculated value.
The following is untested air code, but try the following fix:

Replace this line in the macro:

Please Login or Register  to view this content.

With these two new lines:

Please Login or Register  to view this content.