Hi there,

I would appreciate if somebody can help me with this simple looking query.

I have two columns. In First column user can select one team name from the
list of 5 defined teams. (Used Data-Validation-List)

In other column I want that the list of student names should be displayed
(for user to select) only belonging to the team selected in first cell.

Example:
Team Name Student Name
(allow user to see only students
listed in LAN team)
LAN A
B
C



Regards,
Shweta

Debra covers "dependent lists" at her:
http://www.contextures.com/xlDataVal02.html
Excel -- Data Validation -- Create Dependent Lists
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:370 Subscribers:68
xdemechanik
---
"Shweta Srivastava" wrote:
I would appreciate if somebody can help me with this simple looking query.

I have two columns. In First column user can select one team name from the
list of 5 defined teams. (Used Data-Validation-List)

In other column I want that the list of student names should be displayed
(for user to select) only belonging to the team selected in first cell.

Example:
Team Name Student Name
(allow user to see only students
listed in LAN team)
LAN A
B
C