Excel - Budget remaining

Suppose I have a expense head Internet and have Internet budget say 10000 for a year..
My sheet shoud work like

Sno. | Voucher No. |     Head  |  Amount | Budget remaining
1    |  V74        |  Internet | 3000    | 7000

Means when every I put an expense "Budget remaining" column should show me the remaining budget.

This is *very* basic stuff. Have you ever used a spreadsheet before? Are you
perhaps taking a class?

I am assuming that the header row is row 1, the first data row is row 2, and
the first column is column A.

The first "Budget remaining" cell needs this formula:
=10000-D2

The second "Budget remaining" cell needs this formula:
=E2-D3

For all additional rows, just copy the bottom "Budget remaining" cell down.
(Do *NOT* copy the top "Budget remaining" cell down.)

--
If there is a possibility of several things going wrong,
they will all happen at once.

Have a look at the very simple attachment.
Is this what you mean?


+-------------------------------------------------------------------+
|Filename: salman.way example.zip                                   |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=524|
+-------------------------------------------------------------------+



--
Spencer101