Link multiple cells

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

Guest

I have to link a range of cells between two work books. Is there a way to do this without entering links into each individual cells, i.e. link the whole lot at once?
 
If I read u correctly, here's one way:

1. Select range at source, then Edit>Copy.
2. Select target, then Edit>Paste Special>Paste Link.

HTH
Edmund Seet
 
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

How do I link multiple cells from another workbook? 2
Linked Lists / Data Validation - Excel 97 1
Copy link to offset sheet 5
Linking cells on different sheets within a workbook. 1
Why can I not link my workbooks in excel 2
Can UDF return a customized hyperlink? 3
Copying a block of cells so that it updates automatically 2
Linking cell ranges between rows and columns 1

Back
Top