Good Day,

I need some help, I am handling a records of students and I want to create a search and display form that would help me to lessen my work, I am using pivot table to get the summary but I want to try to have a template that would display a selected data,

I want to have a search box (cell) that if you would type a data as a keyword, multiple or selected data associated to the keyword that I entered on the search box (cell) will display below.

I know it is very simple to all experts here :D

To explain more here is my example.

ex.

I have 50 students divided into 5 different class (class 1-5 as class name)
I have a data of their Name,Address,Telephone No.,Email Add.,Mobile No.
I want to have a search box which if I entered a class name, their data will return or display below. If I type "Class 1" all students in that class will display below (i want to select only what data would display)

Many thanks and hopefully someone could help me.