make cell equal a word if a data validation cell has a word in it
I have 2 data validation cells I want the second cell to equal certain words
in the list if the first data validation cell is selected to certain words. the key is there are a lot of names in the first list but I would like to have it use a common word with all the names like mr or mrs to change the second data cell instead of reffering to the whole name. |
make cell equal a word if a data validation cell has a word in it
Sounds like you want second list items to be dependent upon the first list
selection. See Debra Dalgleish's site for how-to. http://www.contextures.on.ca/xlDataVal02.html Also you seem to be describing some type of Autocomplete. See Debra's site for that also. http://www.contextures.on.ca/xlDataVal10.html Gord Dibben MS Excel MVP On Fri, 6 Feb 2009 08:32:18 -0800, Robzz wrote: I have 2 data validation cells I want the second cell to equal certain words in the list if the first data validation cell is selected to certain words. the key is there are a lot of names in the first list but I would like to have it use a common word with all the names like mr or mrs to change the second data cell instead of reffering to the whole name. |
All times are GMT +1. The time now is 02:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com