Hi,
Can anyone help me with a problem linking multiple cells in a row in one
worksheet to the same number of cells but in a column range in another
worksheet within a different workbook.

The destination worksheet is a summary worksheet which is summarising the
totals from numerous other worksbooks that contain numerous worksheets. In my
summary (destination) worksheet I want to link cells a1 to e1 with cells a150
to a154 in my source worksheet. The source values are formulaes in the source
worksheet that sum the values in the column. I have tried selecting the cells
in the destination worksheet then pressing = and then selecting the source
cells and pressing both Ctrl and enter and also ctrl/shift/enter. Ctrl enter
returns 0 values for all cells where the source cells have a value and the
Ctrl/sift/enter returns an error.

Hope someone can help me. I am using Excel 2003.
--
Ruth