Nov 27, 2013

Reference the value of a cell in a different worksheet

Simply in content of the destination cell just enter: ='Sheet 1'!C22
where:

  • Sheet 1 is the name of the sheet.
  • C22 is the location of the cell in Sheet 1.
(don't forget the apostrophe and the exclamation mark.