LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 25
Default 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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy worksheet from one workbook to a master workbook mvannatta Excel Worksheet Functions 3 April 15th 09 08:32 PM
Save Worksheet To Master Workbook Bobzter100 Excel Discussion (Misc queries) 5 March 12th 09 01:55 AM
Update worksheet from Master workbook txheart Excel Discussion (Misc queries) 0 August 13th 08 09:17 PM
How do I consolidate multiple worksheet files into one workbook Bentbrip Excel Discussion (Misc queries) 1 March 15th 07 09:29 PM
How do I set up a Workbook with a master compiled worksheet and o. Double D Racing Excel Worksheet Functions 1 November 19th 04 06:03 AM


All times are GMT +1. The time now is 11:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"