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 Dcasale@actny.uscg.mil
not uscg.il

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 Dcasale@actny.uscg.mil
> not uscg.il

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 Dcasale@actny.uscg.mil
> not uscg.il