dmac04
10-16-2012, 10:58 AM
Hi,
I'm a total beginner when it comes to VBA, and I have a (to me at least) confusing problem. I have an arbitrary number (let's say three or so) Excel workbooks that need to have their contents merged into another, larger workbook.
Each of the smaller Excel files have three columns of data that I need to add to separate worksheets in the larger workbook. Each smaller file will have say, an A, B and C column, and I need to move these columns to the larger workbook, which will have all of the A columns on worksheet A, all of the B columns on worksheet B, and so on.
My question is, is there any sample code out there for a task like this floating around that I could look at?
I'm a total beginner when it comes to VBA, and I have a (to me at least) confusing problem. I have an arbitrary number (let's say three or so) Excel workbooks that need to have their contents merged into another, larger workbook.
Each of the smaller Excel files have three columns of data that I need to add to separate worksheets in the larger workbook. Each smaller file will have say, an A, B and C column, and I need to move these columns to the larger workbook, which will have all of the A columns on worksheet A, all of the B columns on worksheet B, and so on.
My question is, is there any sample code out there for a task like this floating around that I could look at?