Consolidating data from several workbooks

[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 de Bruin]

Try the examples on my site Emma
http://www.rondebruin.nl/copy3.htm

 

[Emma]

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

message news:[email protected]...

 

[Frank Kabel]

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

 

[Ron de Bruin]

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