Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing Data | Excel Worksheet Functions | |||
Multiple sheets as data for a single sheet | Excel Worksheet Functions | |||
Link excel and word in mail merge without losing your data source? | Excel Discussion (Misc queries) | |||
transfer data in excel between sheets | Excel Discussion (Misc queries) | |||
Extract Data for Mail Merge | Excel Discussion (Misc queries) |