Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default How to consolidate 580 file's data in 1 sheet without oppening all

Hi All,
Please help me on consolidating 580 file's data in one file without oppening
each and every file.If there is any options for importing these files into
single master sheet.
Would appriciate your help.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,276
Default How to consolidate 580 file's data in 1 sheet without oppening all

Hi,
Look at Ron web page he has the solution to your needs

http://www.rondebruin.nl/copy3.htm

If this was helpful please click yes, thanks

"Amit Mahar" wrote:

Hi All,
Please help me on consolidating 580 file's data in one file without oppening
each and every file.If there is any options for importing these files into
single master sheet.
Would appriciate your help.

Reply
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
Consolidate report in Different sheet Krishna Kumar L Excel Discussion (Misc queries) 3 February 8th 09 12:08 PM
Consolidate an XLS sheet smaruzzi Excel Discussion (Misc queries) 3 December 16th 08 01:29 AM
trying to consolidate info into one sheet cabirdy Excel Worksheet Functions 1 March 29th 08 03:59 PM
Consolidate data to summary sheet Ian Excel Discussion (Misc queries) 1 March 8th 08 10:08 PM
Consolidate multiple worksheets into new sheet Angie Excel Worksheet Functions 1 June 6th 07 03:43 PM


All times are GMT +1. The time now is 12:36 AM.

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

About Us

"It's about Microsoft Excel"