| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUM from another worksheet
Worksheet A has a Budgeted Value of $100 and next to it I want a value entered that tells me what I have left from what I have spent The values of what I have spent are on Worksheet B How do I make it to where one Worksheet talks to another? Basically I want to take the total amount from what I spent in Worksheet B and deduct it from by Budget in Worksheet A -- liftapia ------------------------------------------------------------------------ liftapia's Profile: http://www.excelforum.com/member.php...o&userid=33190 View this thread: http://www.excelforum.com/showthread...hreadid=530076 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
SUM from another worksheet
liftapia,
Assuming that your total on Sheet A is in Cell C9, then put this in D9: =C9-Sheet2!E20 where Sheet2 is the name of your Sheet B and E20 is the sum of what you have already spent on that sheet. Make sure you keep the ! in there. Hope this helps! Mark "liftapia" wrote: Worksheet A has a Budgeted Value of $100 and next to it I want a value entered that tells me what I have left from what I have spent The values of what I have spent are on Worksheet B How do I make it to where one Worksheet talks to another? Basically I want to take the total amount from what I spent in Worksheet B and deduct it from by Budget in Worksheet A -- liftapia ------------------------------------------------------------------------ liftapia's Profile: http://www.excelforum.com/member.php...o&userid=33190 View this thread: http://www.excelforum.com/showthread...hreadid=530076 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
SUM from another worksheet
Wonderful !! Thanx SO Much! -- liftapia ------------------------------------------------------------------------ liftapia's Profile: http://www.excelforum.com/member.php...o&userid=33190 View this thread: http://www.excelforum.com/showthread...hreadid=530076 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protect Workbook vs Worksheet?? | Excel Worksheet Functions | |||
| Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
| Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) | |||
| Weekly Transaction Processing | Excel Worksheet Functions | |||
| copyright and worksheet protection | Excel Discussion (Misc queries) | |||
Linear Mode
