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