View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
davesexcel
 
Posts: n/a
Default 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