View Single Post
  #2   Report Post  
JulieD
 
Posts: n/a
Default

Hi Heath

if you mean that you want cell A27 on sheet 2 to display what ever is in A3
on sheet 1, the "easiest" way to do it is click in cell A27 on sheet 2, type
an
=
then click on A3 on sheet 1 and press enter. The formula
=Sheet1!A27
will be put into the cell for you. You could, of course, just type this
yourself. However, you need to remember, if the sheet name contains spaces
you need to put ' ' around the sheet name, e.g.
='Jan Figs'!A27

Regards
JulieD

"Heath" wrote in message
...
I would like to set a function for a cell,that displays the cell on another
page.