Is there away to link something on one page to another?
 

Hello i was wondering if anyone could help me.

Im doing a project for my NVQ4 course and before i can start i would like to
know if there is anyway that using excel you can type one thing say on sheet
1 but link it so it comes on automacially on say sheet 4?

Many thanks for all replies!

Nickle

3 methods to choose from.

1. On sheet 4 select a cell and enter an = sign.
Switch to sheet 1 and select the cell to link.
Hit ENTER key.

2. In cell on sheet 4 enter =sheet1!cellref

3. Select a cell on sheet 1 and copy then switch to sheet 4 and select
a cell then Paste SpecialPaste Link.


Gord Dibben Excel MVP


On Mon, 24 Jan 2005 13:29:05 -0800, "nickelback"
wrote:

Hello i was wondering if anyone could help me.

Im doing a project for my NVQ4 course and before i can start i would like to
know if there is anyway that using excel you can type one thing say on sheet
1 but link it so it comes on automacially on say sheet 4?

Many thanks for all replies!