Hi all
I am new to VBA ,I need some help .I have problem like below: I need VBA macro code where in it should auto fill row 5 & 6 if it finds name matching "A" and "B".
Means I need to type in only one row .so that wherever the macro finds matching name it should auto fill subject and marks .

A B C
1 Name subject Marks
2 A ENG 60
3 B Sci 55
4 C SS 25
5 A
6 B

Please help
Regards
Nag