S
Sumeth
I need help to solve 2 problems. Any one could help me pls.
column A column B
1 province 3 John
2 province 2 Barbara
3 province 3 Sam
4 province 3 Lilly
above is my data.
1)I want to have drop down list in cell("c1") to show a1:a4 (sort a-z) like
this
province2
province3
2)if in the cell("c1") is province2 the cell("d1") could show drop down
list only "Barbara"
thanks,
column A column B
1 province 3 John
2 province 2 Barbara
3 province 3 Sam
4 province 3 Lilly
above is my data.
1)I want to have drop down list in cell("c1") to show a1:a4 (sort a-z) like
this
province2
province3
2)if in the cell("c1") is province2 the cell("d1") could show drop down
list only "Barbara"
thanks,