LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dan Connors
 
Posts: n/a
Default running balance in Excel

Hello,
My running balance is set up fine. I have it in a List. What I would like
is to have is one cell at the top of my sheet that always has my "Final
Balance". This number could change of course, depending on the data entered.
Maybe I'm going about this the wrong way...

Basically what I'm trying to do...
I have about 100 customers that purchase coupons. Their coupons go up or
down depending on if they use them or buy more. I have each customer on their
own sheet, and they each have their own running balance. I then wanted one
sheet that I can go to and get every customers current balance. This is why
I'm trying to grab the last cell in my list...because that is their current
balance. I want to take that balance and put it in cell so it could be more
easily summarized. I'm guessing that Access would be a better bet for me, but
I was having big problems with the running totals. Any ideas or suggestions
would be greatly appreciated!!!
 
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
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
Stop excel from dropping the 0 in the beginning of a number? Rosewood Setting up and Configuration of Excel 12 April 4th 23 02:12 PM
When running a SAP report Excel will only display results if Excel isn't already open peternoy Excel Discussion (Misc queries) 0 January 19th 06 11:03 AM
with new print server, excel running slow intermittently Mcmaineacjam Excel Discussion (Misc queries) 1 August 31st 05 03:09 PM
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM


All times are GMT +1. The time now is 02:48 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"