Hi
I want populating items in data validation in column G based on select one of the option buttons .
if I select optionbutton1 , then should populate list column J in column G , if I select optionbutton2 , then should populate list column K in column G .
with some notices:
1- I don't want any duplicates names in data validation for column G when populate items .
2- I don't want any empty in in data validation for column G when populate items .
3- if I add new names for two lists in columns J,K , then should populate items in data validation for column G automatically .
I hope some body help
thanks in advance .
Bookmarks