Consolidate all sheets across multiple workbooks

Hi All,

I came across the following code, which does exactly what i want. It opens up all workbooks in a specified folder, and consolidates these into one. Each worksheet data is added below that of the previous workbook.

https://sites.google.com/a/madrocket.../wbs-to-sheets

I have changed this to suit my workbook which has the header rows starting in row 6, but is now giving an error due ot the copy area not being the same size as the past area. It appearsto be copying columns A:M and trying to paste this into the main workbook in columns A:N.

can anyone see where i have went wrong? I admit that i am new to this, and struggling to fully understand every step of this code.

Please Login or Register  to view this content.

Hi,

Sorry. I must have cut something during an edit. My workbooks have multiple sheets, and all of these need merged with the exception of the first one. I did try to adjust the code to skip the first sheet, but then reversed this change. I must have missed something when reversing this alteration.

Thanks

The error is "1004: copy area is not the same size of the paste error. Try selecting a single cell..."

This error appears to happen at the following line

Please Login or Register  to view this content.

If I look at what is currently highlighted on this line, it appears to be trying to copy the range A:M from the currently opened workbook into a range A:N into the main workbook. So these are not the same size, and are indeed 1 column size different.

As I have confessed, I am not 100% about that this code is on this line is doing. But my gut is telling me it is something to do with the range we have selected in the second parenthesis. I could be way of the mark though.

Thanks.

Apologies, that should never have been there as it is not actually present in my code. This is a typo as I am currently stuck using a tablet. I will repost my full code here tomorrow.

I will also try to adapt this so that we are not copying the full row, but rather just select a column range. And see what difference this makes.

Thanks,

Andrew

Issue Solved.

I had a column which was not 'cleansing' after each run, so the spreadsheet would eventually hit its limit and run out of destination rows.

Thanks

what was the final code?