Merging specific Worksheets into one Master Worksheet

**dagindi** · 11-19-2009, 03:14 PM

Thanks to the great team of people on Excel Forum, I have been able to create a lot of worksheets in minutes that would have taken me hours.

I am stuck on the following:

I have 5 folders.
Each folder has one workbook.
Each workbook has 10 worksheets of data which I converted over using a text to excel macro. Each worksheet represents a week so the work books will continue to grow.

I run a macro that takes all the data from the 10 worksheets in that folder and creates a "Master Worksheet".

I would like to know if there is a macro that will "look" in each folder for the Master Worksheet created from the other 10 worksheets and then merge it all to one Super Mastersheet which can be in a new workbook. From there I intend to put together a Pivot Table.

All sheets have the same columns & headers, but different amount of rows.

Thanks!

**jaslake** · 11-19-2009, 09:05 PM

Hi dagindi
This procedure will do just what you described.

Please Login or Register  to view this content.

It'll need to be adapted to your specific needs. If you need help with that, let me know.
John

**dagindi** · 11-24-2009, 07:24 PM

John,

I don't know if your checking/subscribing to this thread but I have not forgotten about this request.

I've been slammed with some other things and want to take the time to understand how this code works before I post again.

Hopefully in the next few days I will be able to try and see if I can tailor it to my needs.

Thanks

DG