software

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?
--
Dennis

Hi!

In Sheet2 G50 enter:

=Sheet1!A31

Biff

quot;Dennisquot; gt; wrote in message
...
gt;A simple question by example. Say I have a value in ws1, cell a31, of 345.
gt; I would like whatever the value of that cell to also be shown in ws 2,
gt; cell
gt; g50. How do I do that?
gt; --
gt; Dennis
Hi Dennis

In Sheet2 cell G50 enter =Sheet1!A31

--
Regards

Roger Govierquot;Dennisquot; gt; wrote in message
...
gt;A simple question by example. Say I have a value in ws1, cell a31, of
gt;345.
gt; I would like whatever the value of that cell to also be shown in ws 2,
gt; cell
gt; g50. How do I do that?
gt; --
gt; Dennis
Biff,

Thanks you very much. I told you it was a simple question. It works.
--
Dennisquot;Biffquot; wrote:

gt; Hi!
gt;
gt; In Sheet2 G50 enter:
gt;
gt; =Sheet1!A31
gt;
gt; Biff
gt;
gt; quot;Dennisquot; gt; wrote in message
gt; ...
gt; gt;A simple question by example. Say I have a value in ws1, cell a31, of 345.
gt; gt; I would like whatever the value of that cell to also be shown in ws 2,
gt; gt; cell
gt; gt; g50. How do I do that?
gt; gt; --
gt; gt; Dennis
gt;
gt;
gt;

=if(sheet1!a31=quot;quot;,quot;quot;,sheet1!a31)

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

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

--

Dave Peterson

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.

--
Dennisquot;Roger Govierquot; wrote:

gt; Hi Dennis
gt;
gt; In Sheet2 cell G50 enter =Sheet1!A31
gt;
gt; --
gt; Regards
gt;
gt; Roger Govier
gt;
gt;
gt; quot;Dennisquot; gt; wrote in message
gt; ...
gt; gt;A simple question by example. Say I have a value in ws1, cell a31, of
gt; gt;345.
gt; gt; I would like whatever the value of that cell to also be shown in ws 2,
gt; gt; cell
gt; gt; g50. How do I do that?
gt; gt; --
gt; gt; Dennis
gt;
gt;
gt;

Got it! Thanks much.
Dennis
--
Dennisquot;Dave Petersonquot; wrote:

gt; =if(sheet1!a31=quot;quot;,quot;quot;,sheet1!a31)
gt;
gt; (there's a difference in what you'll see if sheet1, cell A31 is empty.)
gt;
gt; Dennis wrote:
gt; gt;
gt; gt; A simple question by example. Say I have a value in ws1, cell a31, of 345.
gt; gt; I would like whatever the value of that cell to also be shown in ws 2, cell
gt; gt; g50. How do I do that?
gt; gt; --
gt; gt; Dennis
gt;
gt; --
gt;
gt; Dave Peterson
gt;