Duplicating cell value between worksheets
 

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

Duplicating cell value between worksheets
 

Hi!

In Sheet2 G50 enter:

=Sheet1!A31

Biff

"Dennis" wrote in message
...
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

Duplicating cell value between worksheets
 

Hi Dennis

In Sheet2 cell G50 enter =Sheet1!A31

--
Regards

Roger Govier


"Dennis" wrote in message
...
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

Duplicating cell value between worksheets
 

Biff,

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


"Biff" wrote:

Hi!

In Sheet2 G50 enter:

=Sheet1!A31

Biff

"Dennis" wrote in message
...
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

Duplicating cell value between worksheets
 

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

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

Dennis wrote:

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

--

Dave Peterson

Duplicating cell value between worksheets
 

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


"Roger Govier" wrote:

Hi Dennis

In Sheet2 cell G50 enter =Sheet1!A31

--
Regards

Roger Govier


"Dennis" wrote in message
...
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

Duplicating cell value between worksheets
 

Got it! Thanks much.
Dennis
--
Dennis


"Dave Peterson" wrote:

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

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

Dennis wrote:

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

--

Dave Peterson