D darlylj Apr 20, 2008 #1 I am trying to create a formula using references from another sheet within the same workbook
M Mike H Apr 20, 2008 #2 a bit more detail would be useful but perhaps this which looks at sheet 2 from any other sheet and returns the value in a1 =Sheet2!A1 Mike
a bit more detail would be useful but perhaps this which looks at sheet 2 from any other sheet and returns the value in a1 =Sheet2!A1 Mike
G Gord Dibben Apr 20, 2008 #3 =SUM(Sheet1!A1:A23) entered in any cell in Sheet2 Gord Dibben MS Excel MVP
