Scenario:

I have 300+ workbooks. I need to copy columns C:LastActive (populated) column from the workbooks to a master workbook.

Example:

WB A ----> Copy from column C:LastPopulated to Master WB starting with the first blank column.

So essentially, I have my master WB run the macro select the file and it will copy over. Rinse and repeat.

Where do I start?

Thanks.