Multi workbook data dump.

[André]

Hi there, I have created 1 workbook and have copied it 3
times (one copy for each employee that will be using it).
I have also made a master copy where I would like all the
data to be dumped into. The employee's WB's have a range
from B3 to M56. What I would like to have happen is that
the data from the 3 workbooks get added together and that
the resulting data gets dumped into the master WB but I
need the data to populate the same fields (B3 to M56).
Can this be done?

thanks

A.
/dazed and confused

 

[Paul]

Hi there, I have created 1 workbook and have copied it 3
times (one copy for each employee that will be using it).
I have also made a master copy where I would like all the
data to be dumped into. The employee's WB's have a range
from B3 to M56. What I would like to have happen is that
the data from the 3 workbooks get added together and that
the resulting data gets dumped into the master WB but I
need the data to populate the same fields (B3 to M56).
Can this be done?

In each of the cells B3:M56 of the master workbook you need a formula to add
the values from the equivalent cell in each of the three employee workbooks.
The best way for you to do this, getting the syntax correct, is as follows.

Open all four workbooks.
In B3 of the master, start entering the formula by typing =
Navigate to the first employee workbook (Window menu, click on the workbook
name) and select cell B3.
Type +
Navigate to the second employee workbook and select cell B3.
Type +
Navigate to the third employee workbook and select cell B3.
Press Enter.

Then, in the master workbook, copy cell B3 and paste it into B3:M56.

 

[Guest]

Thanks Paul, that's what I though i had to do but I just
couldn't get it to work when i tried it last. Worked fine
this time tho.
thanks again.