Drop-down list in Excel

  • Thread starter Thread starter Sheela
  • Start date Start date
S

Sheela

Hello,

I want to create a drop-down list in Excel where as I
type the value in the cell, it should be added in the
drop-down list automatically. Can I use the worksheet
function or do I have to use VBA? I have tried using the
Data Validation and it can only be taken from another
range of cell. I don't want it like that.

Can anybody help me in this!

Thanks.
 
If your list is a defined name that adjusts for new entries you could just
add to the list
insert>name>define>name it something like mylist>in the refers to box
type(if your list is in col A)
=offset($A$1,0,0,counta($A:$A),1)
Don't put anything under the list.
Excel will automatically put in the sheet name for you so do this while at
the sheet where the list is.
Now in the drop down where you select list then type in =mylist
Then whenever you add/delete to the list it will self adjust.
 
Back
Top