How do I duplicate value in multiple worksheets in same workbook?

[jwnorris]

When I change the value in Worksheet A, Cell C4 I want it to also change the value in Cell D8 in Worksheet B. How do I do this?

[Gord Dibben]

In D8 of worksheet B enter =worksheetA!C4


Gord Dibben Excel MVP

On Sat, 3 Dec 2005 12:03:17 -0600, jwnorris
<[email protected]> wrote:

>
>When I change the value in Worksheet A, Cell C4 I want it to also
>change the value in Cell D8 in Worksheet B. How do I do this?

[Nick Hodge]

On worksheet B Cell D8 enter

='Worksheet A'!C4

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
[email protected]HIS


"jwnorris" <[email protected]> wrote in
message news:[email protected]...
>
> When I change the value in Worksheet A, Cell C4 I want it to also
> change the value in Cell D8 in Worksheet B. How do I do this?
>
>
> --
> jwnorris
> ------------------------------------------------------------------------
> jwnorris's Profile:
> http://www.excelforum.com/member.php...o&userid=29324
> View this thread: http://www.excelforum.com/showthread...hreadid=490421
>

[Armadillow]

I am a shortcut freak...so, in the cell where you want the information to end
up (Cell D8 in Worksheet B.) press the = keyuse CTRL and go to your source
(Worksheet A, Cell C4), place your cursor on the cell. This should bring up
your friendly blinking dashing line. The HIT ENTER!!!! This will place the
information in the "end up" cell, and you will be on Worksheet B.

"Nick Hodge" wrote:

> On worksheet B Cell D8 enter
>
> ='Worksheet A'!C4
>
> --
> HTH
> Nick Hodge
> Microsoft MVP - Excel
> Southampton, England
> www.nickhodge.co.uk
> [email protected]HIS
>
>
> "jwnorris" <[email protected]> wrote in
> message news:[email protected]...
> >
> > When I change the value in Worksheet A, Cell C4 I want it to also
> > change the value in Cell D8 in Worksheet B. How do I do this?
> >
> >
> > --
> > jwnorris
> > ------------------------------------------------------------------------
> > jwnorris's Profile:
> > http://www.excelforum.com/member.php...o&userid=29324
> > View this thread: http://www.excelforum.com/showthread...hreadid=490421
> >
>
>
>