how to sort the data in drop down list
 

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,

how to sort the data in drop down list
 

Not quite what you asked, but you could rearrange your data, add some workbook
names and then use a technique from Debra Dalgleish's site:
http://contextures.com/xlDataVal02.html


Sumeth wrote:

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,

--

Dave Peterson

how to sort the data in drop down list
 

Thanks Dave.
I can do it right now.

"Dave Peterson" wrote:

Not quite what you asked, but you could rearrange your data, add some workbook
names and then use a technique from Debra Dalgleish's site:
http://contextures.com/xlDataVal02.html


Sumeth wrote:

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,

--

Dave Peterson