how do i add a list to the existing drop down list?

[Lorelie]

Please inform me by replying to my email address. thanks.

 

[Gord Dibben]

Asked here.........answered here.

Simply add items to the current list then re-define the range in
Insert>Name>Define.


Gord Dibben MS Excel MVP