totaling to a different sheet
 

I have 2 work sheets, 1 is weekly time card, the other expenses. I want
to keep a running total of hours worked from sheet one, and milage
driven, material expenses, and reimbursement from sheet 2, listed on
sheet 3. can this be done?


--
-Brian-H-


------------------------------------------------------------------------
-Brian-H-'s Profile: http://www.excelforum.com/member.php...fo&userid=5665
View this thread: http://www.excelforum.com/showthread...hreadid=465762

Brian,

Lets say that sheet1 cell a1 contains (hours) 45 and that sheet2 cell
a2 contains (expenses) 958

In sheet 3 all you need to do is "point" it at the relevent cells in
sheets one and two

=+sheet1!a1 will return the value of cell a1 in sheet one (45)
=+sheet2!a2 will return the value 958

Cheers


--
Jon Quixley
------------------------------------------------------------------------
Jon Quixley's Profile: http://www.excelforum.com/member.php...o&userid=25803
View this thread: http://www.excelforum.com/showthread...hreadid=465762