Transferring cell totals...

L

Lise

I have 2 sheets per employee, week 1 and week 2. How do i
transfer those totals from each week into the Final sheet?

Also how do i go about showing/attaching my file into this
thread?

Lise
 
F

Frank Kabel

Hi
you could use simple formula like
='sheet_employee_1'!A20

Note: please do NOT attach files to this newsgroup. You could post some
sample data in plain text!
 
L

Lise

still need help..

file saved is "pr template test" and within that week 1
and week 2 tabs at the bottom. This is my Testing
employee which is in cell A1. I'd like to transfer totals
from week 1 and 2 cell's c37 into a new worksheet that is
saved as "adp payroll test" into cell g6.

Lise
 
F

Frank Kabel

Hi
try the following:
- open both files
- select your target cell
- enter the equation sign '='
- select your source cell with the mouse and hit ENTER
 
L

Lise

Worked! Thanks ;0)
-----Original Message-----
Hi
try the following:
- open both files
- select your target cell
- enter the equation sign '='
- select your source cell with the mouse and hit ENTER

--
Regards
Frank Kabel
Frankfurt, Germany


.
Click to expand...
 
Top