Validation & Combo
 

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

Validation & Combo
 

You may have to re-explain the finally bit but try this to start with

Put your Jobs and names in Columns A & B and select them, then

Data|List|Create list.

Select a job in Column A will display the people who do those jobs in Column
B and filter out the rest.

Mike

"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

Validation & Combo
 

"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.