Linking Workbooks


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?
 
Ad

Advertisements

S

Stephen

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?

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.
 
Ad

Advertisements

C

Charlie M

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

Top