title: Excel- Preventing cell references from changing when the data in those references is moved around
body: <p>I have a range of cells that references another range of cells on another sheet. For our purposes today let's say $C1:$C10 references $A1:$A10. Now theoretically whatever gets put in A1 should go to C1 and whatever goes in A2 goes to C2. This part works fine. </p>
  
  <p>Where I'm running into an issue is if I want to reorder the list in A1:A10. If cut and insert A10 into A1 everything shifts down and all the data is still between A1:A10 but nothing in C1:C10 has changed except now C10 references A1. I have changed reference types($A$1, $A1 and A$1) but no luck. </p>
  
  <p>I essentially want the freedom to move around or replace data within A1:A10 and have C1:C10 automatically update. </p>