ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Links and Linking in Excel (https://www.excelbanter.com/links-linking-excel/)
-   -   copy table from multiple spreadsheets and paste them into one (https://www.excelbanter.com/links-linking-excel/447381-copy-table-multiple-spreadsheets-paste-them-into-one.html)

stmnik

copy table from multiple spreadsheets and paste them into one
 
hi everyone,
i have a series of 800 spreadsheets all having the same table (in terms of position and size).
i would like to copy all and paste them into to one spreadsheet one below the other. and i don't mean manually ;-)


All times are GMT +1. The time now is 08:28 PM.

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