I see.

If you select the same size array in the summary sheet, hit F2, type
=numbers in the formula bar and then commit with Ctrl-Shift-Enter (as an
array formula).

the range name applies to the whole workbook, not just the sheet, unless you
create it as a worksheet name by preceding with the sheet name in the names
definition.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Brad Zenner" wrote in message
...
Sorry, the example was, I have data in a range of cells 6 columns wide by
5
rows (30 cells total), that I created a named range for, let's call that
range "numbers" for example.

Is there a formula that on the master sheet, instead of referring to a
specific cell, I could refer to a range of cells? For example, in cell A1,
could I write:

=Sheet2!"numbers" ? Would that then populate the 30 cells on the master
sheet?

Does that make sense?
Thanks again Bob, sorry I'm not explaining better
BZ



On 8/15/05 6:24 PM, in article , "Bob
Phillips" wrote:

Drag and copy isn't so bad, if the cells on the region sheets are
contiguous, adding references to the summary would be simple.

I am not sure I understand the statement ... Is it possible to do that
with
a named cell range of 5
rows by 6 columns, to have references for all of those 30 cells at
once?