Merge / Collate Workbooks into 1 Workbook

H

hassesbar

Grateful for help with urgent problem, which requires automation:
I've got 50 workbooks
Each workbook is named after an Area

Each workbook contains:
Cell A1, Column Header 'Area'
Cell B1, Column Header 'Zip Code'
A2 to unknown number of rows contains the Area Name
B2 to unknown number of rows contains different zip codes relating t
that area

I want to merge/collate all this data into one workbook. Please se
example below:

AREA ZIP COD
Dallas 11111
Dallas 11111
Dallas 11111
Dallas 11111
NYC 22222
NYC 22222
NYC 22222
Chicago 33333
Chicago 33333
Chicago 33333
Chicago 33333
Chicago 33333

As it stands at the moment, the areas listed in the workbook exampl
above are all in 50 different workbooks.

Many Thanks,

Chri
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merge / Collate Workbooks into 1 workbook 1
Import multiple workbooks to current workbook in specified row number 0
Macro to merge workbooks onto one worksheet 1
Separating a master file into many workbooks 2
modifying merge all workbooks.. 3
Separating one large workbook into several smaller workbooks 2
How can I Merge Worksheets from different Excel Files into one Worksheet? 1
Consolidate Workbooks with Single header Row 7

Top