linking worksheets

  • Thread starter Thread starter j van c
  • Start date Start date
J

j van c

I know ho to link cells to oher cells. But is there a convenient way to link
ranges or worksheets to others.
 
Hi
just link the first cell
e.g. ='sheet1'!A1
and copy this formula for your range. The reference will adapt
automatically
 
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

Excel VBA 1
Stop linked cells from changing when insert new row? 1
Link behavior with changing data set 3
Link in worksheet 3
Link to the FIRST worksheet 3
Cells act as if they are linked-link does not display in entry bar 1
Copying linked sheet 2
link to another document of Excel 2003 2

Back
Top