Linking Workbooks

  • Thread starter Thread starter Charlie M
  • Start date Start date
C

Charlie M

How can I link a range of cells to another workbook, using named cells, if
the data isn't located in the same position in each workbook?
 
Charlie M said:
How can I link a range of cells to another workbook, using named cells, if
the data isn't located in the same position in each workbook?
Click to expand...

Why is this a problem? Suppose a cell in your source workbook contains data
you want to access. You name this cell. Then in the destination workbook you
reference this cell by its name. The cells don't have to be in the same
place in the two workbooks.
 
Stephen:

It works fine if I link one cell at a time. I'm having a problem linking
C11:N11 (named total1) from the source workbook to E11:P11 in the destination
workbook.

I go to the destination workbook, highlight E11:P11, press =, select the
source workbook from the windows menu, press F3 and click ok, and press
enter. A linked amount appears only in cell E11 of the destination workbook.
I'm not sure what I'm doing wrong.

CM
 

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 to create absolue path link to another workbook (Excel 2003) 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel Highlighting duplicates 0
Link behavior with changing data set 3
Excel VBA 0
Sharing workbooks limitations - Merged Cells 12
Excel Protection 2
Macro to push data to another workbook 0

Back
Top