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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 Special>Paste Link.


Gord Dibben Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying Sheets between workbooks without links 3
PLEASE HELP - Link Data from Different Sheets to Summary Page 3
Excel VBA - counting cells by colors and names to it in two different rows. 0
Auto-fill text - links to other sheets 2
Page Numbers/Names listed on a Summary sheet? 5
Excel Unique last page footer 1
How copy automatically from one sheet to another. 4
i need to find the exact location of macro to paste in the existing macro need to get the out put co 0

Back
Top