Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Keep running total of mult. inputs
I am trying to create a form that can keep a running total
of dollars entered into a certain category. The form would have a drop down list of "cost categories." Usually, only one cost category would be used each time the form is used. However, I would like to keep up with how much has been entered into each category as the form is used. Is there a way to track the dollars entered on the form for each category each time the form is used? e.g. 1st time form is used: A B 1 Category Amount 2 Whatever $100 Then the form is printed out for distribution. 2nd time form is used: A B 1 Category Amount 2 Whatever $150 Is there a VB program or something that can tell me at this point that as of this 2nd time, $250 has been allocated to the "Whatever" category without just having a really long list of every transaction? Is there some way to keep a running total of that category each time the form is accessed? By the way, a different category could be selected each time the form is used. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Keep running total of mult. inputs
You could create defined names (insert=Name=Define) and store your
running total there. You could do this with the code in your userform. Regards, Tom Ogilvy "Robert" wrote in message ... I am trying to create a form that can keep a running total of dollars entered into a certain category. The form would have a drop down list of "cost categories." Usually, only one cost category would be used each time the form is used. However, I would like to keep up with how much has been entered into each category as the form is used. Is there a way to track the dollars entered on the form for each category each time the form is used? e.g. 1st time form is used: A B 1 Category Amount 2 Whatever $100 Then the form is printed out for distribution. 2nd time form is used: A B 1 Category Amount 2 Whatever $150 Is there a VB program or something that can tell me at this point that as of this 2nd time, $250 has been allocated to the "Whatever" category without just having a really long list of every transaction? Is there some way to keep a running total of that category each time the form is accessed? By the way, a different category could be selected each time the form is used. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Keep running total of mult. inputs
I guess I'm not quite advanced enough. Could you provide
some specifics? -----Original Message----- You could create defined names (insert=Name=Define) and store your running total there. You could do this with the code in your userform. Regards, Tom Ogilvy "Robert" wrote in message ... I am trying to create a form that can keep a running total of dollars entered into a certain category. The form would have a drop down list of "cost categories." Usually, only one cost category would be used each time the form is used. However, I would like to keep up with how much has been entered into each category as the form is used. Is there a way to track the dollars entered on the form for each category each time the form is used? e.g. 1st time form is used: A B 1 Category Amount 2 Whatever $100 Then the form is printed out for distribution. 2nd time form is used: A B 1 Category Amount 2 Whatever $150 Is there a VB program or something that can tell me at this point that as of this 2nd time, $250 has been allocated to the "Whatever" category without just having a really long list of every transaction? Is there some way to keep a running total of that category each time the form is accessed? By the way, a different category could be selected each time the form is used. . |
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) | |||
running total | Excel Worksheet Functions |