| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dynamic Subtotal
Hi All,
I have a list of cables and with beginning total (length) of each one. throughout the year, users are filling rows with type of cable and the amount they took or received to the warehouse. (Headers: Cable Type,Income Amount,Outcome Amount). I need to calculate the balance between the received and taken so it will be dynamically. I can use Subtotal but I will need to do it all the time over and over again. Is there another solution that doesn't concern VBA? Thanks a lot in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I Subtotal, then Sort by Subtotal Amounts? | Excel Discussion (Misc queries) | |||
| pasting to subtotal lines without replacing hidden -non-subtotal l | Excel Discussion (Misc queries) | |||
| Bolding the subtotal lines automaticlly When using the Subtotal fu | New Users to Excel | |||
| copy subtotal value only, subtotal value can be vlookup by others | Excel Discussion (Misc queries) | |||
| Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
Threaded Mode
