| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do you calculate a running balance in multiple worksheets?
calculate a running total on multiple worksheets
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do you calculate a running balance in multiple worksheets?
more details needed. running total on each sheet?
Pete "strawberryangel83" wrote in message ... calculate a running total on multiple worksheets |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do you calculate a running balance in multiple worksheets?
Ok. I have done 3 worksheets with formulas in them. My boss now wants me to
have it to where there is a master worksheet, with the others conjoined to it. the main worksheet will be the master account with the total of all expense accounts. the others are for other workers and their expense accounts, which they all add up to the totals on the main sheet. i hope i did not confuse you! "Pete_UK" wrote: more details needed. running total on each sheet? Pete "strawberryangel83" wrote in message ... calculate a running total on multiple worksheets |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do you calculate a running balance in multiple worksheets?
Hi,
You may want to read up on the Data Consolidate feature. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "strawberryangel83" wrote in message ... Ok. I have done 3 worksheets with formulas in them. My boss now wants me to have it to where there is a master worksheet, with the others conjoined to it. the main worksheet will be the master account with the total of all expense accounts. the others are for other workers and their expense accounts, which they all add up to the totals on the main sheet. i hope i did not confuse you! "Pete_UK" wrote: more details needed. running total on each sheet? Pete "strawberryangel83" wrote in message ... calculate a running total on multiple worksheets |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do you calculate a running balance in multiple worksheets?
You have answers at your other post.
Pete On Nov 4, 12:07*am, strawberryangel83 wrote: Ok. *I have done 3 worksheets with formulas in them. *My boss now wants me to have it to where there is a master worksheet, with the others conjoined to it. the main worksheet will be the master account with the total of all expense accounts. *the others are for other workers and their expense accounts, which they all add up to the totals on the main sheet. i hope i did not confuse you! "Pete_UK" wrote: more details needed. running total on each sheet? Pete "strawberryangel83" wrote in ... calculate a running total on multiple worksheets- Hide quoted text - - Show quoted text - |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do you calculate a running balance in multiple worksheets?
it was really confusing to me though. so that is why i just want to do a
formula. i tried to do the ones that i saw in the help section, but it never works "Ashish Mathur" wrote: Hi, You may want to read up on the Data Consolidate feature. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "strawberryangel83" wrote in message ... Ok. I have done 3 worksheets with formulas in them. My boss now wants me to have it to where there is a master worksheet, with the others conjoined to it. the main worksheet will be the master account with the total of all expense accounts. the others are for other workers and their expense accounts, which they all add up to the totals on the main sheet. i hope i did not confuse you! "Pete_UK" wrote: more details needed. running total on each sheet? Pete "strawberryangel83" wrote in message ... calculate a running total on multiple worksheets |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| multiple wk sheets - running balance | Excel Discussion (Misc queries) | |||
| 2007 and running balance across worksheets | Excel Worksheet Functions | |||
| rent received/balance owed/running balance spreadsheet | Excel Discussion (Misc queries) | |||
| How do I calculate a running balance? | Excel Worksheet Functions | |||
| calculate a running balance | Setting up and Configuration of Excel | |||
Linear Mode
