Data Validation Ammendment

[Continental Translations]

I have set up two drop down menus which use data validation. The results of
the second drop down menu depend on what was selected in the first drop down
menu.

Nonetheless, now I want to ammend one of my list. I have tried adding my new
determining factor in the next cell and then highlighting all the cells and
naming the cells again, however whenever I press "return", it just
highlights the original cells, unhighlighting the new one.

Any help?

 

[Peo Sjoblom]

Do insert>name>define, select the name and in the refers to box change the
range and click add or select the new range,
insert>name>define, type the name and click add

--


No private emails please, for everyone's
benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom

 

[Continental Translations]

Simple as that!

Thanks a lot!

Do insert>name>define, select the name and in the refers to box change the
range and click add or select the new range,
insert>name>define, type the name and click add

--


No private emails please, for everyone's
benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom

 

[Frank Kabel]

Hi
see: http://www.contextures.com/xlDataVal02.html