"Celline" wrote:

I have following data :
Col A -Category Col B -Name
Teacher Jessie
Teacher James
Doctor Susan
Farmer Brayn
Farmer Michael
How can i do in list box or validation in order to:
once user click in column A, he can select Teacher, Doctor, Farmer in Col A
(something like filter, same category only appear 1 time),after select
Teacher, Column B will apear only Jessie & James (those name under doctor
category) to let user to choose

Finally,
w/sheet will have Doctor(Col A) Jessie(Col B if user choosed Jessie) & user
can key in figure in column C
U can use the Pivot Table to get the desired result.
Data - -Pivot Table , go through the entire wizard, select the appropriate
Layout [Row Column] and get the table created.
In that u will get the filter type option.