LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jimmy James
 
Posts: n/a
Default How do i set up a running balance on one row?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
running balance in excel mphillips Excel Worksheet Functions 2 September 7th 05 05:16 PM
TABLE WITH RUNNING BALANCE Donna Cas Excel Discussion (Misc queries) 2 August 30th 05 09:49 PM
How do i get the running balance from one worksheet to another? Spoardy Excel Worksheet Functions 4 August 2nd 05 08:58 PM
How do I calculate a running balance? Susan Excel Worksheet Functions 1 July 29th 05 03:22 AM
how : check register running balance is a stationary cell Michele Excel Discussion (Misc queries) 9 January 19th 05 05:25 PM


All times are GMT +1. The time now is 10:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"