Changing the range for my drop down menu

[Erinayn]

I have a daily checklist that I created that has drop down menus with
people's names so I can select who sent the document that day. Recently there
has been a new person that sends and I'd like to add them to the drop down
choices.

I've added the new name under the 1 name (the group only had one) and
highlight the 2 cells and rename the range in the name box it doesn't take.
It still has the original 1 name as the range.

What am I doing wrong?

 

[FSt1]

hi
don't use the name box to rename.
2003 on the menu bar....
insert>name>define
delete the old name before renaming the new range.

regards
FSt1

 

[Jim Thomlinson]

You need to hit the add button. That being said it sounds like you could
benefit from a dynamic named range...

http://www.cpearson.com/excel/excelF.htm#DynamicRanges

 

[Gord Dibben]

The DV dropdown is still using the original listname as the source.

Assuming your list range is named MyList and refers to A1

You want to add A2 to the list range

Insert>Name>Define.

Select MyList and change the "refers to:" address to =Sheet1!$A$1:$A$2

OR delete the original MyList and create a new MyList with the two cells.

Or change the name in the DV source dialog to match the new one.


Gord Dibben MS Excel MVP

 

[Erinayn]

Thanks... I deleted the prior one under the insert>name>define and added the
new name selected the cells and created a new one.

Thanks for the help