Using Data Form

  • Thread starter Thread starter Robert
  • Start date Start date
R

Robert

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?

Thanks, Robert
 
Ron,

Thanks for the leads, however I would like to write formula / code as this
requirement is on a number of PCs and I don't want to buy the code for each
machine.

The VBA part that I can't get right is naming a range, using macro record, I
select the first cell, then holding the shift key press End and Home keys.
I then name the range. Looking at the macro this refers to R1C1 etc. etc.

Any help most welcome. Robert
 
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
 
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.
 
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
 
Back
Top