B
bowling
Hello,
Currently am working on excel sheet. I’ve created 2 sheets. Sources and
destination. In destination sheet I’ve 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
Currently am working on excel sheet. I’ve created 2 sheets. Sources and
destination. In destination sheet I’ve 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