Tom,

Thanks for the tip, I never realised that the name "database" did this. I
have several lists, each on a separate sheet within a workbook and I have
found to my delight, that prefixing database with the sheet name allows for
multiple database range names.

Thanks, Robert


"Tom Ogilvy" wrote in message
...
If you name your range database (not with a dynamic formula definition,
but
refering to the current data) and add your information using the dataform,
then the dataform will automatically extend the definition of database.

--
Regards,
Tom Ogilvy

"Robert" wrote in message
...
Debra,

Thank you ever so much, dynamic range is just the thing. I tried
=vlooup(A1,Customers!A:H,2) which seems to also work i.e. row number not
entered - just don't understand why this method worked.

Thanks, Robert


"Debra Dalgleish" wrote in message
...
You could create a dynamic range named 'Database'. There are
instructions he

http://www.contextures.com/xlNames01.html

Robert wrote:
Excel 2000

I have a list of customers which I add to each day and then have to
redefine
the range name i.e. extend to include the last row or rows which I
entered.

I have been using the built-in feature of Data Form and although I
can
run
this by clicking a button assigned with the code
ActiveSheet.ShowDataForm, I
can't seem to figure out how to extend the range.

Do I need VBA code or a formula that expands?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html