Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
adding and subtracting using vb codes
I have a table listing items in column 'A'. How do I keep a running total of
the individual items as they are entered. Below is an exemple of my table. A B C D Item Stock in Stock out Stock left Nails 100 70 30 Clips 100 60 40 As the items are entered I wish the total in column D be kept up to date for the individual item. Thank you. -- ASU |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
adding and subtracting using vb codes
The formula in column D would be =B3-C3, then copy the formula down the
length of the column -- Kevin Backmann "ASU" wrote: I have a table listing items in column 'A'. How do I keep a running total of the individual items as they are entered. Below is an exemple of my table. A B C D Item Stock in Stock out Stock left Nails 100 70 30 Clips 100 60 40 As the items are entered I wish the total in column D be kept up to date for the individual item. Thank you. -- ASU |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
adding and subtracting using vb codes
Thanks for getting so quick. What I was looking for is how do I keep a
running total of individual items. eg if I add more nails to the list it would keep a running total of that item only. And if like wise with other items. I hope thats clear!!! -- ASU "Kevin B" wrote: The formula in column D would be =B3-C3, then copy the formula down the length of the column -- Kevin Backmann "ASU" wrote: I have a table listing items in column 'A'. How do I keep a running total of the individual items as they are entered. Below is an exemple of my table. A B C D Item Stock in Stock out Stock left Nails 100 70 30 Clips 100 60 40 As the items are entered I wish the total in column D be kept up to date for the individual item. Thank you. -- ASU |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rounding Error when adding or subtracting two cells | Excel Worksheet Functions | |||
How to display 5.5 hours instead of 5.30 when adding \ subtracting | Excel Discussion (Misc queries) | |||
trouble with subtracting cells and adding text... | Excel Discussion (Misc queries) | |||
trouble with subtracting cells and adding text... | Excel Discussion (Misc queries) | |||
Adding Subtracting Time Formula-Horse Racing | Excel Discussion (Misc queries) |