Excel drop down - Very Urgent**

[Mkeerthi]

I have a data in Sheet1 with Coloum A1 Name: Class X then A2,A3,A4 are the names of students in Class X and Column B1 Name: Class IX and then B2, B3, B4 are the names of students in Class IX and then Coloum C1 name: Class VIII and then C2,C3,C4 are the names of students in Class VIII.

Now in Sheet 2 I want to create a drop down in Column A:Class and Column B:Student Name such a way that if I select Class X in the drop down of Column A it should show the only the student names of Class X in the drop down of Column B. Is this Possible?

 

[oldbrewer]

show us a few rows of data a picture is worth a thousand words

 

[louisH]

Hi,

In column A use Data Validation list with source :

=Sheet1!$1:$1

In column B use Data Validation list with source :

=OFFSET(Sheet1!$A$2:$A$1000,0,MATCH($A1,Sheet1!$1:$1,0)-1)

Assuming there's no more than 1000 students in 1 class

 

[steve the fish]

Its simple enough if a little time consuming. Take a look here:

http://www.contextures.com/xlDataVal02.html

 

[oldbrewer]

name	class
name1	C1
name2	C2
name3	C3				class	C2
name4	C1
name5	C2				Count of name
name6	C3				name	Total
name7	C1				name11	1
name8	C2				name14	1
name9	C3				name17	1
name10	C1				name2	1
name11	C2				name20	1
name12	C3				name5	1
name13	C1				name8	1
name14	C2				Grand Total	7
name15	C3
name16	C1
name17	C2
name18	C3
name19	C1
name20	C2				a pivot table lists who is in the selected class

<colgroup><col span="5"><col><col><col span="4"></colgroup><tbody>
</tbody>

 

[Mkeerthi]

Class X	Class XI	Class VIII
Arul	Ram	Samuel
Arun	Mohan	Sai
Vijay	Rao	Hari
Vinay	Murthy	Ravi
Venkatesh	Bharat	Reddy
Mohan	Venky	Rajendra
Karthik		Rasool
Sudharsan		Teja

<colgroup><col width="64" style="width: 48pt;" span="3">
<tbody>













































</tbody>

 

[Mkeerthi]

But this is just a sample of data and my requirement is much more there by I am looking for only drop down as solution.

 

[Mkeerthi]

I am going through the link. Hope this should be the solution. Will come back I meet my requirements with a thank you note.

 

[Mkeerthi]

It worked out. Thanks a Ton.