Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In Excel, how do you make one whole sheet equal to another. | Excel Discussion (Misc queries) | |||
Clicking Cell Link Changes Cell on Another Sheet | Excel Discussion (Misc queries) | |||
Get other sheet names into a column | Excel Worksheet Functions | |||
Using a relative SHEET reference for source data in a chart | Charts and Charting in Excel | |||
Does excel recognise names rather than cells? | Excel Worksheet Functions |