title: Get the BALANCE for each item for every Row
body: <p>I'm trying to perform a VBA Function or 1 solutions that minus row by row based on stock (available quantity), order by date. <br/>
  I'm actually using ADO to import item list &amp; quantity, use SQL command to Group by STOCK Quantity from another sheet, and I planned to put all information to the same array, start to minus rows by row OR use SQL command do anything in recordset (just an idea, I don't know whether is it possible/ good way or not).<br/>
  I hope to have any example that similarly to this or any keyword that I can find and learn. Also, any idea and comment will be greatly appreciated.
  <br/></p>
  <p>This is the stock:</p>
  <pre><code>Item  Quantity
  A     10
  B     9
  C     1
  D     5
  </code></pre>
  <p>The result will be look like this:</p>
  <pre><code>Item  Date    Quantity  Balance
  A     25 Dec  4         6
  B     24 Dec  4         -4 
  A     27 Dec  5         1
  B     23 Dec  9         0
  A     29 Dec  3         -2
  D     21 Dec  4         1
  D     25 Dec  3         -2
  C     22 Dec  2         -1
  </code></pre>