Home |
Search |
Today's Posts |
#1
|
|||
|
|||
TABLE WITH RUNNING BALANCE
need an excel table. needs the starting balance, the date, vendor name,
amount and have it deducted from the running balance, very simple like a check book. thank you Donna my email is not uscg.il |
#2
|
|||
|
|||
Example:
A2=vendor name B2=date C2=amount D1=beginning balance D2=ending balance (formula =D1-C2) As you add rows of data, copy the formula down. The cell references are relative so that you will have your running balance. -- Elisabeth "Donna Cas" wrote: need an excel table. needs the starting balance, the date, vendor name, amount and have it deducted from the running balance, very simple like a check book. thank you Donna my email is not uscg.il |
#3
|
|||
|
|||
THANK YOU ELIZABETH, YOUR TABLE WORKED!!
"Donna Cas" wrote: need an excel table. needs the starting balance, the date, vendor name, amount and have it deducted from the running balance, very simple like a check book. thank you Donna my email is not uscg.il |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I calculate a running balance? | Excel Worksheet Functions | |||
Pivot table (Running Averages) | Excel Worksheet Functions | |||
how : check register running balance is a stationary cell | Excel Discussion (Misc queries) | |||
List Running Horizontally-Pivot Table Possible? | Excel Discussion (Misc queries) | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) |