Posts

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 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.