Well, you posted to the .newusers group, so don't be shy about asking
follow-ups.

Dominic was suggesting that you define a dynamic range. That means you
don't name specific cells.

Instead, choose the Insert/Name/Define menu item. In the "Names in
workbook" textbox enter "Data" (without the quotes).

In the "Refers to:" textbox, enter the formula, then click "Add". You
can use Dominic's formula, or, if you don't have any blank rows, this
formula will also work:

=OFFSET(Sheet1!$D$13,0,0,COUNTA(Sheet1!$D$13:$D$65 536),1)


Adjust the references for your sheet (e.g., if you sheet is named
"Staff", use

=OFFSET(Staff!$D$13...

For an alternative explanation, see

http://cpearson.com/excel/named.htm#Dynamic


In article ,
Sherry wrote:

I risk causing some upset here but...............Ummmmm
What does that all mean Domenic? Some dumb questions to follow!!

Which cell do I name Data???

Where do I place
=Sheet1!$D$13:INDEX(Sheet1!$D$13:$D$65536,MATCH(9. 99999999999999E+307,She
et1!$D$13:$D$65536)) ????

Where do I use the formula... =AVERAGE(Data)

Perhaps I should have included the fact that I am very new to this functions
and macro stuff. A point that I am sure after this post will become painfully
obvious. LOL