Merge / Collate Workbooks into 1 Workbook
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 -- hassesba ----------------------------------------------------------------------- hassesbar's Profile: http://www.excelforum.com/member.php...fo&userid=2818 View this thread: http://www.excelforum.com/showthread.php?threadid=47712 |
Merge / Collate Workbooks into 1 Workbook
hi hassesbar
Start here http://www.rondebruin.nl/copy3.htm -- Regards Ron de Bruin http://www.rondebruin.nl "hassesbar" wrote in message ... 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 to that area I want to merge/collate all this data into one workbook. Please see example below: AREA ZIP CODE 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 example above are all in 50 different workbooks. Many Thanks, Chris -- hassesbar ------------------------------------------------------------------------ hassesbar's Profile: http://www.excelforum.com/member.php...o&userid=28182 View this thread: http://www.excelforum.com/showthread...hreadid=477127 |
All times are GMT +1. The time now is 07:44 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com