Consolidate specific cells from all workbooks in a directory

Hey Guys,

I want to extract data from 30 files, with the same structure, that I have placed in a directory together with the consolidation file.

The idea is to run a macro on the consolidation file with the following instructions:

1. Copy from Sheet Data1, Range C6:C26, to the first empty column on the consolidation file, sheet "Cons", Range B2:B22 (next one must be on C2:C22, then D2:D22, etc).
2. Copy from Sheet Data1, Range D6:D26, to the first empty column on the consolidation file, sheet "Cons", Range starting from cell B29:B39
3. Copy from Sheet Data1, Range E6:E26, to the first empty column on the consolidation file, sheet "Cons", Range starting from cell B57:B67
4. Copy from Sheet Data1, Range F6:F26, to the first empty column on the consolidation file, sheet "Cons", Range starting from cell B85:B95
5. Close this file and process the next one

Is this something easy to do ?

Thank you in advance!

Your first range is 21 cells each in the source and the destination ranges.

But the next 3 copy ranges are still 21 cells each, but the destination range are only 11 cells. I'm ignoring that in this solution and making all the targets 21 cells, too.

Please Login or Register  to view this content.

Oops! (blush)

Fixed above, all the RESIZE parameters were hitting columns instead of rows. I also forgot to increment the columns as we work through the data books.