View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ASU ASU is offline
external usenet poster
 
Posts: 63
Default adding and subtracting using vb code

Is there a way to use vb codes to carry out adding, subtracting and to keep a
running total on individual items on a table? below is a small part of my
table.

A B C D
Item Stock in Stock out Stock held

Nails 100 20 80
Clips 100 50 50
Clips 0 20 30
Nails 50 10 120
and so on.

Items can be added to the table. Col 'D' keeps a running total of each
separate items.

Thank you.
--
ASU