reference a cell on another sheet

J

JcR

what is fomula to reference cell on another sheet of same workbook ?

I want cell a1 on sheet one to equeal cell a5 on sheet 2

thanks
 
D

davesexcel

JcR said:
what is fomula to reference cell on another sheet of same workbook ?

I want cell a1 on sheet one to equeal cell a5 on sheet 2

thanks
Click to expand...
Just hit the equals sign when you are on cell A1 and go to that cell on
sheet 2 and hit enter
 
Top