View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lp12 Lp12 is offline
external usenet poster
 
Posts: 54
Default 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