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?