Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
The built in Excel help gave me some new ideas (search for "Calculate a
running balance" in excel help), but I still want to see if someone out there knows how to do what I'm trying to do. I've set up a budget on excel, where all I have to do is enter in how much my paycheck was for that week, and it will divide it up among preset impound accounts according to my calculations. I would then take the divided up amounts and manually enter them into my quickbooks program, which, after only a month or two, is driving me crazy. I HATE double entry. I'm trying to establish a running balance directly on my excel spreadsheet, preferably on only one line, that will save my current totals, and allow me to re-use that same spreadsheet to enter in my Next paycheck, and so on. I also would like a million dollars tax free, but that ain't happening either, I know. Pretty much, all I'm trying to do is avoid double entry. If I can set up a formula, or input field of some sort, I wouldn't care if I have to have more than one line. I just don't want to have to recreate the formula on a whole new workbook/worksheet, because it takes just as long as what I was doing. Last question, is it possible there's already a program out there that will do this? Hoping there's a genius or two out there, -Jim |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
running balance in excel | Excel Worksheet Functions | |||
TABLE WITH RUNNING BALANCE | Excel Discussion (Misc queries) | |||
How do i get the running balance from one worksheet to another? | Excel Worksheet Functions | |||
How do I calculate a running balance? | Excel Worksheet Functions | |||
how : check register running balance is a stationary cell | Excel Discussion (Misc queries) |