ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How to consolidate 580 file's data in 1 sheet without oppening all (https://www.excelbanter.com/excel-worksheet-functions/228652-how-consolidate-580-files-data-1-sheet-without-oppening-all.html)

Amit Mahar

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.

Eduardo

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.



All times are GMT +1. The time now is 07:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com