Does anyone know how to add an item from a cell on sheet 1 to a cell on sheet 2?
I Ivan T. Williams Jan 25, 2006 #1 Does anyone know how to add an item from a cell on sheet 1 to a cell on sheet 2?
D Dave Peterson Jan 25, 2006 #2 if the formula cell is on sheet2. ='sheet1'!a1+b99 (b99 is on sheet2, so it doesn't need the sheet name in front of it.)
if the formula cell is on sheet2. ='sheet1'!a1+b99 (b99 is on sheet2, so it doesn't need the sheet name in front of it.)
