| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Consolidate a worksheet from different workbook into one master
Hi,
I have been trying to automate the consolidation of the "first" worksheet from several workbook's having two or more worksheet's with same layout. Each workbook is in the same folder named "Total". I want the data of the 1st worksheet in each of these say around 25 workbooks in a Master workbook named "Master" in the first worksheet to be consolidated one below the other. Kindly help me out on this. Prashanth KR. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Consolidate a worksheet from different workbook into one master
Try the add-in or use the code from the links on that page
http://www.rondebruin.nl/merge.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Prashanth KR" wrote in message ... Hi, I have been trying to automate the consolidation of the "first" worksheet from several workbook's having two or more worksheet's with same layout. Each workbook is in the same folder named "Total". I want the data of the 1st worksheet in each of these say around 25 workbooks in a Master workbook named "Master" in the first worksheet to be consolidated one below the other. Kindly help me out on this. Prashanth KR. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Consolidate a worksheet from different workbook into one maste
Thank you very much Ron...... I got what I required. And your Tip sheet is excellent. I shall use it for my daily work. Thanks a Ton, Prashanth KR. "Ron de Bruin" wrote: Try the add-in or use the code from the links on that page http://www.rondebruin.nl/merge.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Prashanth KR" wrote in message ... Hi, I have been trying to automate the consolidation of the "first" worksheet from several workbook's having two or more worksheet's with same layout. Each workbook is in the same folder named "Total". I want the data of the 1st worksheet in each of these say around 25 workbooks in a Master workbook named "Master" in the first worksheet to be consolidated one below the other. Kindly help me out on this. Prashanth KR. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy worksheet from one workbook to a master workbook | Excel Worksheet Functions | |||
| Save Worksheet To Master Workbook | Excel Discussion (Misc queries) | |||
| Update worksheet from Master workbook | Excel Discussion (Misc queries) | |||
| How do I consolidate multiple worksheet files into one workbook | Excel Discussion (Misc queries) | |||
| How do I set up a Workbook with a master compiled worksheet and o. | Excel Worksheet Functions | |||
Linear Mode
