title: Excel : Formula with cell updating
body: <p>I have an excel sheet ("month payslip") in which there is a payslip with a <em>lot</em> of formulas.
  <br>There is some value that changes each month like the <strong>Nomber of hours</strong> to make it simple.
  <br>The amount earned after charges is computed in this first sheet.</p>
  
  <p>In another sheet ("year payslip"), I have a table with, for each month, the <strong>number of hours</strong> worked in the month. 
  <br>I would like excel to compute the net salary for each month, using the first sheet to compute it.</p>
  
  <p>It would be easy with a VBA macro that does the following process :</p>
  
  <ol>
  <li>Copy hours of month <strong><em>i</em></strong></li>
  <li>Paste it on the sheet 1</li>
  <li>Copy the computed Salary</li>
  <li>Paste it on the sheet 2 just below month <strong><em>i</em></strong></li>
  <li>Do it again for month <strong><em>i + 1</em></strong></li>
  </ol>
  
  <p><strong>But I want to know if this simple process is possible <em>only with formulas</em> and without <em>VBA</em></strong></p>