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