title: Link columns so data updates are properly reflected
body: <p>I have a column with data values and I want to link it to other columns in the same and different sheets but in the same spreadsheet. This is, having the same data in different columns in a spreadsheet while keeping all linked so updates on the source one would affect all of them.</p>
  
  <p>I've tried with:  </p>
  
  <pre><code>=SheetName!ColumnIndex:ColumnIndex  
  </code></pre>
  
  <p>(e.g. <code>=Sheet1!A:A</code>) but, although it works, it is a cell reference not a column reference.</p>
  
  <p>What is the best way to achieve it?</p>