View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rusty[_5_] Rusty[_5_] is offline
external usenet poster
 
Posts: 1
Default 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