title: Updating absolute references while copying a formula
body: <p>I've got a huge table with a lot of formulas, and some of them refer to cells in an absolute way (i.e. <code>$C$3</code> instead of <code>C3</code>).</p>
  
  <p>How can I now duplicate this table in the same sheet, while updating the value of the absolute references, but keeping them still absolute (i.e. <code>$C$3</code> should become <code>$I$3</code>)?</p>
  
  <p>Rewriting each formula while removing any existing <code>$</code> would be such an annoying work...</p>