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
HIS


"jwnorris" wrote in
message ...

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