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
|