merge data from many sheets to one
We have 160 spreadsheets of data that need to be entered into one spreadsheet
-weekly. Actually, there are 40 locations with 4 spreadsheets each, same setup at each location. There are about 100 fields of data that we need from each location. We pull the spreadsheets in and can then hopefully merge this data into one spreadsheet. The end result would be a spreadsheet with forty rows with 100 fields of data. What do we compose that we can use weekly to automatically merge the data from the 160 spreadsheets into one spreadsheet?? Thanks for advice. jb |
merge data from many sheets to one
Hi JB
Start here for a code solution http://www.rondebruin.nl/copy3.htm -- Regards Ron de Bruin http://www.rondebruin.nl "jb" wrote in message ... We have 160 spreadsheets of data that need to be entered into one spreadsheet -weekly. Actually, there are 40 locations with 4 spreadsheets each, same setup at each location. There are about 100 fields of data that we need from each location. We pull the spreadsheets in and can then hopefully merge this data into one spreadsheet. The end result would be a spreadsheet with forty rows with 100 fields of data. What do we compose that we can use weekly to automatically merge the data from the 160 spreadsheets into one spreadsheet?? Thanks for advice. jb |
All times are GMT +1. The time now is 05:05 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com