Linking worksheets

  • Thread starter Thread starter Christine
  • Start date Start date
Christine said:
How do I link sheet 1 with sheet 2?
Click to expand...

Hi Christine
in cell A1 of your sheet 1 enter the equation sign '='. Now
activate/select the other worksheet with the mouse and select the cell
which should be linked. Hit enter
or enter the formula manually
='sheet2'!A2

Frank
 
Christine

In Sheet2 A1 enter =Sheet1!A1 to link A1.

OR enter an = sign in A1 of Sheet2 and switch to Sheet1 A1 and hit the ENTER
key.

OR copy Sheet1 A1, switch to Sheet2 A1 and Paste Special>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

Worksheet linking 2
linking a range of cells (=) to another range 4
Linking worksheets 2
Link to another worksheet 1
creating links in between worksheets 2
Creating a template that I can reproduce every month by keying ininformation from SAP 8
Assign Macro with Hidden Sheet 4
Worksheet + 1 1

Back
Top