Showing posts from November, 2013

Reference the value of a cell in a different worksheet

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

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