Linking a range from an external workbook to a single cell

[philipd]

I am linking a series of workbooks to a summary work book. I need to
know if I can enter a cell range from the external workbooks to a
single cell in a summary workbook.

In this instance I have 12 months data stored in workbook A in 12
seperate columns. I know I can link each cell in workbook A to a
corresponding cell in workbook B. However this requires me to link each
of the 12 cells in workbook A to the 12 in workbook B. I would like to
enter in the first cell in workbook B the start of the range of 12
cells in workbook A and automatically generate the same range in
workbook B.

I have tried using cell names and naming the range in workbook A but if
I use =name in workbook B I just get the #value! error.

 

[Frank Kabel]

Hi
why not enter the first link. e.g.
='[book2.xls]sheet1'!A1
and then copy this formula?

 

[philipd]

I can do this but I have literally 100's of links and therefore wa
looking for something quicker and more efficient

 

[Frank Kabel]

Hi
if the are within a range just drag this cell with the first link. you
may give an example with your cell references in both workbooks. There
may be a better solution