running total.....hepl!!!

  • Thread starter Thread starter Guest
  • Start date Start date
G

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????
 
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.
 
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!
 
Back
Top