I am buying a car and I want to put the payments that i am making on a
worksheet that will automatically subtract my payments from the original
amount, lets say I am paying 5,500 paying 50.00 a week how can i create this
worksheet?

Here's one way:

A1 = header = Starting Balance
B1 = 5500

A2 = header = Total Paid to Date
B2 = formula: =SUM(B6:B300)

A3 = header = Current Balance
B3 = formula: =B1-B2

A5 = header = Date
B5 = header = Amount Paid

Select cell A6
Goto the menu WindowFreeze Panes

As you make payments and scroll down the sheet your balance will always be
visible on top.

--
Biff
Microsoft Excel MVP


"TW" wrote in message
...
I am buying a car and I want to put the payments that i am making on a
worksheet that will automatically subtract my payments from the original
amount, lets say I am paying 5,500 paying 50.00 a week how can i create
this
worksheet?