Changing the range for my drop down menu

E

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?
 
F

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
 
G

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
 
E

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top