Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.links
|
|||
|
|||
linking a range
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 |
#2
Posted to microsoft.public.excel.links
|
|||
|
|||
linking a range
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 |
#3
Posted to microsoft.public.excel.links
|
|||
|
|||
linking a range
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Runtime Error 9, Subscript Out of Range. When linking between word | Excel Discussion (Misc queries) | |||
Linking Workbooks using file names in a range | Excel Worksheet Functions | |||
linking to a named range in another workbook | Excel Discussion (Misc queries) | |||
forecasting and linking to a data range that is fluctuating | Excel Discussion (Misc queries) | |||
Linking Range | Excel Discussion (Misc queries) |