Duplicating cell value between worksheets

[Dennis]

A simple question by example. Say I have a value in ws1, cell a31, of 345.
I would like whatever the value of that cell to also be shown in ws 2, cell
g50. How do I do that?

 

[Biff]

Hi!

In Sheet2 G50 enter:

=Sheet1!A31

Biff

 

[Roger Govier]

Hi Dennis

In Sheet2 cell G50 enter =Sheet1!A31

 

[Dennis]

Biff,

Thanks you very much. I told you it was a simple question. It works.

 

[Dave Peterson]

=if(sheet1!a31="","",sheet1!a31)

(there's a difference in what you'll see if sheet1, cell A31 is empty.)

 

[Dennis]

Roger,
Thank you for your prompt response to my question. It feels great to have
the answer after spending hours trying to research this by reading manuals.
Newsgroups and responders are wonderful.

 

[Dennis]

Got it! Thanks much.
Dennis
--
Dennis

=if(sheet1!a31="","",sheet1!a31)

(there's a difference in what you'll see if sheet1, cell A31 is empty.)