Running total using macro
 

i have made a spreadsheet which calculates how much
packaging the company has used to send out to customers.
This is something that has to be done for SEPA (Scottish
Environmental Agency). when i in put data of one of our
products the spreadsheet works out how many boxes, tyoe of
box ,etc. For the past year there have been hundreds of
orders and each on needs to be put through the
spreadsheet. i need to keep a running total of the tonnage
of packaging for every new item entered, i think the best
way to do this is to have a command button to update the
running total for everytime i enter new data. my problem
is that i dont know visual basic.can anyone help

cheers

Running total using macro
 

Hi Rusty
if you only want a running total for all rows you may use the following
formula (for column B):
=SUM(OFFSET($B$1,0,0,COUNTA($B:$B))
sums all entries in column B 8assumption: no blank rows in between)
--
Regards
Frank Kabel
Frankfurt, Germany

Rusty wrote:
i have made a spreadsheet which calculates how much
packaging the company has used to send out to customers.
This is something that has to be done for SEPA (Scottish
Environmental Agency). when i in put data of one of our
products the spreadsheet works out how many boxes, tyoe of
box ,etc. For the past year there have been hundreds of
orders and each on needs to be put through the
spreadsheet. i need to keep a running total of the tonnage
of packaging for every new item entered, i think the best
way to do this is to have a command button to update the
running total for everytime i enter new data. my problem
is that i dont know visual basic.can anyone help

cheers