title: Create mirror Tables in Excel
body: <p>I need to create two mirror tables in my sheet. With "mirror" I mean that they will have exactly the same values (at least in the column I need) and whatever changes I do to the one will automatically be transferred to the other e.g. when I insert a row in Table1 it will automatically insert a row in Table2.</p>
  
  <p>I have tried doing that with the "Relationships" option, VLOOKUP but none of these worked. Hardcoding the range with relative reference is also not a solution as I need to keep my table clear of blank cells. Finally, it would be ideal not to use a macro for that but I will not turn down a solution that includes one.</p>
  
  <p>Does anyone know if this is doable and have any idea on how to do it? Thank you! </p>