I want to fill the table with corresponding data depends on user selection in the drop dow

Hi Friends,

1. have 2 sheets in the work book. one is having data of exams and results by month wise
2. In second sheet I have combo box which lists all the months . when I select a month, i want to display corresponding months data in this sheet and a chart for that data.

Please refer attached excel sheet for more clarity.

Appreciate your quick help in this regard.

-Rk

Try in G9:

=INDEX(example!$C$8:$K$16,MATCH($F9,example!$B$8:$B$16,0),MATCH($F$8,example!$C$6:$K$6,0)+COLUMNS($G9:G9)-1)

copied across and down.

Hi maruthi,

I believe a pivot table with a month filter would do what you need. Watch:
http://www.youtube.com/watch?v=Dv7TMGc181I

See attached.

Here is a Pivot Method. You could/should rearrange the table to look like the example.

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.