copy columns vs. rows

Hello all,

I've been working on a macro that combines raw data files. I'm only interested in certain columns of data within the raw files that can be in any order. I've used the following code to copy column data into my worksheet.

Please Login or Register  to view this content.

The problem is not all the columns are fully populated depending on the data and blanks get filled while looping through workbooks and misalign data.

Is there a way I can loop through rows of a worksheet, if they contain some type of data, copy only those fields that match the column headings I want for that row (blanks are fine)? Data from the next workbook should start on the next row even if column A for example has 15 entries and column B has 20.

This is basically starting the macro on a new slate for me, any help is most appreciated!!!

Hello Jaslake,

Thank you so much for your help. Your changes did the trick!