Here's the template: E-CLASSRECORD_WEDZ.xls

actually, these are my problems...

1. the boys' list of names reflect on the MTB sheet BUT when I add new rows on INPUT DATA sheet... there are no rows added on the MTB sheet.

2. the girls' list are not updating correctly.. it still shows the boys' names.