How to gather data from different excel workbooks into 1?

T

T. Harrouz

Suppose we have several different workbooks (not shared) containing the same
fields on a server location.Each user update his own workbook daily.I need
(the controler) to gather the data in another workbook and report the daily
updates for all the users in a table,but needs it to be automatic, and
showing these results in detail.I have a perfect background but don't know
how to connect the points.Please help,thank you.
 
G

Gary Rowe

You can also extract the data from the other workbooks into your own workbook
through Data/Import External Data/New Database Query. Once you have the data
in your spreadsheet you can combine the data into one table by using the same
method but use a union query on each sheet to combine them together. You can
have your queries set up for automatic refreshing by setting the query
properties.
 
Top