title: Calculate between two sheets excel
body: <p>I'm new to excel and I would like some help on this. </p>
  
  <p>I have two spreadsheets. On the first sheet, I enter job information and in the second sheet, there is a list of total number of stocks corresponding to their work ids.</p>
  
  <p>This is what I want to do:</p>
  
  <pre><code>Sheet 1:
  ---------------
  A1         B1        C1
  Ordered  In stock  Work ID
  5          95       ABC
  
  Sheet 2:
  --------------
  A1              B1
  Total Stock   Work ID
   100           ABC
  </code></pre>
  
  <p>In Sheet 1, as the user enters the number of stock ordered [A1], it should subtract from the total stock in Sheet 2 and show the remaining balance in both - cell B1 of Sheet 1 and A1 of Sheet 2. </p>
  
  <p>When the user enters another job of the same work ID, it should subtract from the current total i.e  95 [A1 of Sheet 2] </p>
  
  <pre><code>Sheet 1:
      ---------------
      A5         B5        C5
      Ordered  In stock  Work ID
      15         80       ABC
  
      Sheet 2:
      --------------
      A1              B1
      Total Stock   Work ID
       95*           ABC
  </code></pre>
  
  <p>What would be the best way to do this?</p>
  
  <p>*should become 80.</p>