Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Running Total | Excel Worksheet Functions | |||
Duplicate Running Total Grand Total In Pivot Table | Excel Discussion (Misc queries) | |||
running total and average of that total after 3 events | Excel Discussion (Misc queries) | |||
running total and average of that total after 3 events | Excel Discussion (Misc queries) | |||
having a running total | Excel Discussion (Misc queries) |