H
hassesbar
Grateful for help with this 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
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