Thread: How do i add a new entry to an existing drop-down list in Excel?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre Ron Coderre is offline
external usenet poster
  
Posts: 698
Default How do i add a new entry to an existing drop-down list in Excel?
Would you be interested in using a Dynamic Range Name, which would
automatically expand and contract to match the data volume?
(no vba programming necessary)

See Debra Dalgleish's website for instructions:
http://www.contextures.com/xlNames01.html#Dynamic

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"ABD" wrote:

I've named the list of options in a new sheet in the same workbook. When I
try to add a new option to the existing list, it will not let me rename the
new list (which includes the new entry) the old name.
Reply With QuoteReply With Quote