Budget remaining

[salman.way]

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.

 

[Spencer101]

Suppose I have a expense head Internet and have Internet budget sa
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 sho
me the remaining budget.

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
+-------------------------------------------------------------------

 

[Auric__]

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'm 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.)