merge data from many sheets to one

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Collate data from one spreadsheet into another spreadsheet 2
Reference constant cells in different files from a master workbook 1
Copy Data from One Spreadsheet to Another ?????? 5
In Excel 07, how do I merge two sprdshts with a common column? 1
Lookups - how to obtain data from a master spreadsheet into another 5
Quick way for monthly linking of Excel sheets 0
Spreadsheet merging problems 1
Merging Excel Sheet with Excel Sheet (Just like in MS Word!) 3

Back
Top