Another option then the already mentioned autofilter would be to use the
pivot table functionality. Look at the help function for pivot table's - it
can generate exactly the overview you specified. Only downside is that you
have to "Refresh" the pivot table manually if you want the latest data to be
included and you have to make sure that the data area of the pivottable keeps
covering your full datarange.

rdwj

"bowling" wrote:

Hello,

Currently am working on excel sheet. Ive created 2 sheets. Sources and
destination. In destination sheet Ive created 3 tables with some spaces for
each table. What I need is, when I enter data in sources sheet it should come
under appropriate table according to the school name. Below is the sources
and destination sheet look like.

SOURCE

Name School Age Sex
Cav SMK 20 Male
Beth SHJ 13 Female
John SMU 14 Male
Leena SMK 15 Female



DESTINATION

Name School (SMK) Age Sex


Name School (SHJ) Age Sex


Name School (SMU) Age Sex


All I want is when I type the information in source sheet; it should come
under the table and I have more than 3000 student. So it should increase by
default. How to do this by using VB?

Thank you