I want to type a name in one cell on a worksheet and have it appear in
another worksheet. Basically, type one text entry and you get two - one in
one worksheet and one an another.

Any suggestions?

Say in Cell A1 in sheet 1 enter = then select sheet 2 tab and click on
cell A1 and click enter.

A1 in Sheet 1 is now linked to A1 in Sheet 2.

Hope that's what you wanted.

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=563505

Assume Sheet1 and Sheet2

In Sheet2 select a cell and type an = sign but do not enter yet.

Switch to Sheet1 and select the cell to link to and hit ENTER key.

Whenever you change the cell on Sheet1, the linked cell on Sheet2 will update.

Couple of other ways to do this.

1. copy a cell in Sheet1, switch to Sheet2 and Paste SpecialPaste LinkOKEsc

2. in a cell on Sheet2 enter this formula =Sheet1!cellref where cellref is
the cell to link to.


Gord Dibben MS Excel MVP

On Thu, 20 Jul 2006 15:03:01 -0700, psh221
wrote:

I want to type a name in one cell on a worksheet and have it appear in
another worksheet. Basically, type one text entry and you get two - one in
one worksheet and one an another.

Any suggestions?