Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to gather data from different excel workbooks into 1?
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. |
#2
|
|||
|
|||
Ron de Bruin has lots of code at:
http://www.rondebruin.nl/copy3.htm Maybe you could steal some of it to merge the worksheets into one giant worksheet and process your data from there. T. Harrouz wrote: 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. -- Dave Peterson |
#3
|
|||
|
|||
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. "T. Harrouz" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
Charting Data from Excel | Charts and Charting in Excel | |||
multiple or changing colours in a data table on an excel chart fo. | Charts and Charting in Excel | |||
Excel 97 chart opened in Excel 2003 - Source Data problem | Charts and Charting in Excel | |||
insert data from one excel file into another | Excel Discussion (Misc queries) |