I'm not positive where the problem is that you're having, but to reference something off another sheet, the formula is:
the Sheet1 section is the name of the sheet you want to reference from, the ! is a separator between sheet name and cell, and a1 is the cell you want referenced. You can get this in there by simply typing it into cell A1 in sheet 2, or you could click in the cell on sheet 2, press = and then click on the correct sheet (sheet 1), then the correct cell (a1) and hit enter. This works for numbers, text, anything in fact.
A forum community dedicated to tech experts and enthusiasts. Come join the discussion about articles, computer security, Mac, Microsoft, Linux, hardware, networking, gaming, reviews, accessories, and more!