If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Data Validation Ammendment
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? |
#2
|
|||
|
|||
Data Validation Ammendment
Do insertnamedefine, select the name and in the refers to box change the
range and click add or select the new range, insertnamedefine, 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" wrote in message ... 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? |
#3
|
|||
|
|||
Data Validation Ammendment
Simple as that!
Thanks a lot! Peo Sjoblom wrote in message ... Do insertnamedefine, select the name and in the refers to box change the range and click add or select the new range, insertnamedefine, 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" wrote in message ... 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? |
#4
|
|||
|
|||
Data Validation Ammendment
Hi
see: http://www.contextures.com/xlDataVal02.html -- Regards Frank Kabel Frankfurt, Germany Continental Translations wrote: 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? |
Thread Tools | |
Display Modes | |
|
|