[Joanne]

Is there a way to link a whole range from one workbook to a worksheet in
another workbook?
As it stands with me right now, I have linked cell E4 in wb2 to cell E4
in wb1, but there is a range of approx 8 cols by 52 rows that actually
need to be updated. I tried using the drag handle but it is copying the
value in E4 wb2 to the rest of the cells in the wb2 range.

I need to do this many times over, linking one worksheet in each of
approx 60 workbooks to a different worksheet in the master workbook.
Then, I will use the method again to link the rest of the worksheets in
the destination workbooks to the worksheet from the destination wb that
is linked to the master wb.

Could someone advise me if it is possible to link entire ranges and if
so, how do I do it or do you know of a link to a teaching article that I
could study?
Thank you
Joanne

[Joanne]

Nevermind, I found out what was going on.
The link in E4 was $E$4 (I believe this is an absolute reference) - once
I changed it to E4 (a relative reference) it copied down just fine.

Joanne wrote:

Is there a way to link a whole range from one workbook to a worksheet in
another workbook?
As it stands with me right now, I have linked cell E4 in wb2 to cell E4
in wb1, but there is a range of approx 8 cols by 52 rows that actually
need to be updated. I tried using the drag handle but it is copying the
value in E4 wb2 to the rest of the cells in the wb2 range.

I need to do this many times over, linking one worksheet in each of
approx 60 workbooks to a different worksheet in the master workbook.
Then, I will use the method again to link the rest of the worksheets in
the destination workbooks to the worksheet from the destination wb that
is linked to the master wb.

Could someone advise me if it is possible to link entire ranges and if
so, how do I do it or do you know of a link to a teaching article that I
could study?
Thank you
Joanne

[Sunil Karnatki]

One will need to do some VB scripting for the same. It will need to plot
the cell ref values in the hyperlink position.

"Joanne" wrote in message
...
Is there a way to link a whole range from one workbook to a worksheet in
another workbook?
As it stands with me right now, I have linked cell E4 in wb2 to cell E4
in wb1, but there is a range of approx 8 cols by 52 rows that actually
need to be updated. I tried using the drag handle but it is copying the
value in E4 wb2 to the rest of the cells in the wb2 range.

I need to do this many times over, linking one worksheet in each of
approx 60 workbooks to a different worksheet in the master workbook.
Then, I will use the method again to link the rest of the worksheets in
the destination workbooks to the worksheet from the destination wb that
is linked to the master wb.

Could someone advise me if it is possible to link entire ranges and if
so, how do I do it or do you know of a link to a teaching article that I
could study?
Thank you
Joanne