how to show record from sheet2 to sheet1 based on selection of combo box

Hi ti all,

Just want to ask (macro) in how can do below scenario

I have Sheet1 it has
Name Subject1 Subject2
Combobox ComboBox = combobox has a value coming from sheet5 1styear and 2ndYear


a
b
c
d
e

now i have on sheet2 is the information on subject1 lets say
name 1styear 2ndyear
a 85 88
b 81 89
c 80 82
d 88 81
e 85 86

now what i want is that on sheet 1 when i slect 1styear on the combobox it will show all the grade on 1st year same with 2nd year.

please advise.
thanks.

is there anyone on this forum?

Hi Winon,
im sorry

please find attached document.

as you can see there are 5 sheets
Summary, subject1, subject2,subject3 and sheet1

on summary, what i want is when i select 1st sem on combo box under subject1/Physics
it will show all the record of name a,b,c,d etc on the physics sheet for example
Physics
a 1.00
b 1.25
c 1.75
d 5.00
e 2.00

and when i choose second sem it will show
a 3.00
b 3.00
c 3.00
d 3.00
e 3.00

so as you can see it will be based on the record on each sheet
please advise.
thanks in advance sir.

hope somebody can help me with my problem, should you need more info please don't hesitate to reply here..

excellent! your title suits you, you are really a excel forum guru (bow)