reference a cell on another sheet
 

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

reference a cell on another sheet
 

JcR Wrote:
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
Just hit the equals sign when you are on cell A1 and go to that cell on
sheet 2 and hit enter


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=522939