title: Linking cells to each other; having cells update linked cells and vice versa
body: <p>I have two ideas that could lead to more or less the same result.</p>
  
  <p>I am trying to have similar cells or tables update themselves to whatever the most recent entry was in the linked system. For example, cell A1 is linked to cell B2 (in this system that I am trying to create). I would enter something like "1" or "Text" or whatever in A1 and the system would update cell B2 to whatever I entered in cell A1. However the opposite must work in the same manner. If I changed whatever in cell B2 to, say, "5", cell A1 would also display "5". Also, note that I have Excel 2013.</p>
  
  <p>I need this to work with a cell or a table. So, getting to the possible solutions...</p>
  
  <ol>
  <li><p>A subroutine in VBA that automatically updates all the linked cells or tables.</p></li>
  <li><p>Some sort of mechanic unknown to me that uses VBA or another Excel aspect to do this, like a function or tool.</p></li>
  </ol>
  
  <p>In your answer or solution, please be mindful to my inexperience with VBA. Thanks in advance.</p>