If the ranges are the same size, you can use an array function.

For example, if the original range on Sheet 1 is A1:A5, then on Sheet 2
select a range of five cells and enter the following formula.

=Sheet1!A1:A5

and press CTRL-SHIFT-ENTER to enter the formula into the cells as an
array function, thereby creating an array range.

A nice side effect to this is that you can't change individual cells in
the array range, which helps to prevent mistakes.

Is that what you're looking for?

-Ryan

ken's dilemma wrote:
how do i link a range of cells in one worksheet to a range of cells in
another worksheet? i want the cells to update as i change the originals. i
can link one cell..but when i try to link a range it gives me the #VALUE.
thanx