Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.links
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |