Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merge Shared Workbooks into a Master Workbook | Excel Discussion (Misc queries) | |||
Collate data from many workbooks | Excel Discussion (Misc queries) | |||
How do you merge separate Excel workbooks into one workbook? | Excel Discussion (Misc queries) | |||
MERGE MULTIPAL WORKBOOKS INTO ONE WORKBOOK | Excel Discussion (Misc queries) | |||
I'm trying to merge 2 workbooks into 1 new workbook. | Excel Discussion (Misc queries) |