adding and subtracting using vb codes

G

Guest

I have a table listing items in column 'A'. How do I keep a running total of
the individual items as they are entered. Below is an exemple of my table.

A B C D
Item Stock in Stock out Stock left

Nails 100 70 30
Clips 100 60 40

As the items are entered I wish the total in column D be kept up to date for
the individual item. Thank you.
 
G

Guest

The formula in column D would be =B3-C3, then copy the formula down the
length of the column
 
G

Guest

Thanks for getting so quick. What I was looking for is how do I keep a
running total of individual items. eg if I add more nails to the list it
would keep a running total of that item only. And if like wise with other
items. I hope thats clear!!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

adding and subtracting using vb code 2
cumalative total 2
cummlative totals 4
running total.....hepl!!! 2
SUMIF using cells with commas in 1
Excel 2002: How to fill up text for like items ? 4
alternative formula for VLOOKUP since it stops with the 1st value itself 2
Pivot table: configuring calculated field correctly 4

Top