Consolidating data from several workbooks

  • Thread starter Thread starter Emma
  • Start date Start date
E

Emma

Hi. I have several workbooks that are set up with a
worksheet for each month of the year, on which employees
enter data. I would like another workbook to consolidate
that data. I have tried this with two "test" workbooks
and a "test" consolidation workbook and it worked
beautifully. In trying it with the real data, however, I
get no results. I am using the consolidation dialog box,
selecting the appropriate worksheet range from each source
workbook, and adding that selection. When I tell it to
consolidate, it appears to be working as it shows the
hourglass but then it simply finishes leaving a blank
worksheet. Can you help, please?
 
Ron,

Thanks for the suggestion. I did check out the site, but
am afraid I don't see how this applies. I don't want to
simply copy all the data but to assemble, total it, and
have it automatically update as changes are made. For
example, each employee has a workbook where they will
enter the date, contact name, type of contact, and brief
wording regarding the results, among other things. In
using consolidate, I wanted to be able to see, for
instance, how many speaking engagements our employees had
in a given month, and if those led to additional contacts.
I'm still learning Excel - pivot tables seem to provide
subtotals I need but exclude the additional details.
-----Original Message-----
Try the examples on my site Emma
http://www.rondebruin.nl/copy3.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Emma" <[email protected]> wrote in
Click to expand...
message news:[email protected]...
 
Hi
I doubt that Excel is than the correct tool for you. Sounds more like a
database application if multiple employees have to enter data
separately
 
Hi Emma

You can use formulas in the master sheet to the cells in the other workbooks.
with one of the workbooks open enter = in a cell and go to the other workbook and select
the cell.
You get something like this

='[register example code.xls]Sheet1'!$A$1

If you change it to this($A1) you can copy the formula down

='[register example code.xls]Sheet1'!$A1

If you open the Master workbook you will ask if you want to update the links
 
Back
Top