G
Guest
Can anybody help!!!!
I have the following Table:
A B C D E F G
Supplied Sold Totals Stock
Item 4pers 2pers 4pers 2pers 4pers 2pers
curry 50 50 20 10 30 40
fish 40 40 10 20 30 20
curry 10 10 20 30
Thats only a very small exemple of my table. Is there a way that I can get
col F and G to keep a running total (vb code or formular) of the individual
items as they are added to the table whether data are added to the supplied
or sold columns? Also it has to accommodate any additional items added to the
table. I hope it makes sense.
I have the following Table:
A B C D E F G
Supplied Sold Totals Stock
Item 4pers 2pers 4pers 2pers 4pers 2pers
curry 50 50 20 10 30 40
fish 40 40 10 20 30 20
curry 10 10 20 30
Thats only a very small exemple of my table. Is there a way that I can get
col F and G to keep a running total (vb code or formular) of the individual
items as they are added to the table whether data are added to the supplied
or sold columns? Also it has to accommodate any additional items added to the
table. I hope it makes sense.