ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Copy range from 600 spreadsheets (https://www.excelbanter.com/excel-programming/352876-copy-range-600-spreadsheets.html)

Snowsride

Copy range from 600 spreadsheets
 
I need to copy a range from each of 600 spreadsheets to a single summary
sheet i.e. each range would populate a single row in the summary.

Grateful for any help.



Ron de Bruin

Copy range from 600 spreadsheets
 
Hi Snowsride

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

Or with links
http://www.rondebruin.nl/summary2.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Snowsride" wrote in message ...
I need to copy a range from each of 600 spreadsheets to a single summary
sheet i.e. each range would populate a single row in the summary.

Grateful for any help.





Snowsride

Copy range from 600 spreadsheets
 
Ron

Excellent.

Many Thanks


"Ron de Bruin" wrote:

Hi Snowsride

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

Or with links
http://www.rondebruin.nl/summary2.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Snowsride" wrote in message ...
I need to copy a range from each of 600 spreadsheets to a single summary
sheet i.e. each range would populate a single row in the summary.

Grateful for any help.







All times are GMT +1. The time now is 04:13 AM.

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