I know that you can have entered text appear in another worksheet using CTRL
and clicking the tab for that worksheet, but can you have text you enter
appear automatically in a specifed cell on another worksheet? Using Excel
2000.

If you want anything you type in Sheet1 cell A2 appear in Sheet 2 cell B3,
then click in Sheet 2 cell B3, type the = sign, then click in Sheet 1 cell
A2, and accept the formula. You'll get a formula that says =Sheet1!A2. If
you want your destination cell to stay empty until something has been typed
in the source cell, then use =IF(Sheet1!A2="","",Sheet1!A2).
--
David Biddulph

"i0ndrag0n" wrote in message
...
I know that you can have entered text appear in another worksheet using
CTRL
and clicking the tab for that worksheet, but can you have text you enter
appear automatically in a specifed cell on another worksheet? Using Excel
2000.

Hi,

Do one of the following:

Procedure 1:

1. Select a range in the first sheet.
2. On the Edit menu, click Copy.
3. Click Sheet2 and the select the same range.
4. On the Edit menu, click Paste special. The Paste Special dialog box
appears.
5. Click Paste link button. Then return to Sheet 1 and enter some values in
the cell range. You will noitice that the values are entered in the cells in
Sheet2.

Procedure2:

1. Press the Ctrl key and click the Sheet2. this will group the worksheets.
2. Enter the values in sheet1 and the value in Sheet2.
3. Right-click the seheet and select Ungroup Sheets.

Challa Prabhu

"i0ndrag0n" wrote:

I know that you can have entered text appear in another worksheet using CTRL
and clicking the tab for that worksheet, but can you have text you enter
appear automatically in a specifed cell on another worksheet? Using Excel
2000.