Calculate formula w/in one worksheet but 2 diff. pages

J

JacksGarden

I'm trying to create a formula on Sheet 2 but need to access a field from Sheet 1.
Can't find how to do this via help. Can someone give me the formula.
Thx.
 
F

Frank Kabel

Hi
something like
='sheet1'!A1*B1

or using the mouse:
- enter the equation sign
- select the cell with your mouse
 
Top