running total.....hepl!!!

[Guest]

Is it possible to keep a running total on individual items on a list. I have
a table which on column 'A' lists items (which can be added to), columns B,C
and D are headed..... Items supplied, items sold and stock remaining. Data
entered would be in any order so the the running total would have to deal
with that.
Anybody any ideas????

 

[Guest]

Filtering your data can work for this problem. e.g. filter the items
required in col. A then, on an otherwise unused row you could put a formula
covering the required range i.e. =SUBTOTAL(9,B2:B10) and copy this to col. C
& D. As you add more data, insert extra rows so that the range in the
SUBTOTAL formula changes. I've no doubt there will be other solutions posted.

 

[Guest]

Thanks very much for that. Yes I'v tried that and it works ok, but
unfortunately not quite what I was looking for. I was looking for a vb code
or formula that filtered automatically without having a dropdown box. I'm
sounding abit fussy!! sorry for that!