using excel 2003

Can excel link worksheets by an entire named range on each ws instead of
setting up cell to cell links?

Thanks for the info
Joanne

Let us say I have a named range TEST which refers to sheet1 and covers Range
A1:D10

If I go into another sheet, select A1:D10 (exact same area/location, but in
another sheet), go to the formula bar and enter =TEST and hit CTRL + Enter,
then it does link to the respective cells.

If I go to another part of the sheet and select a comparable area, I need to
do an Array entry

=TEST CTrl+Shift+Enter

and it will work.

--
Regards,
Tom Ogilvy


"Joanne" wrote:

using excel 2003

Can excel link worksheets by an entire named range on each ws instead of
setting up cell to cell links?

Thanks for the info
Joanne