hi there!
im a school registrar, could someone teach me how to put macro on my worksheet:
1. encoded a rows of student details (e.g. First Name, Middle Name, Last Name, age, sex etc.) in sheet 1.
2. in the same sheet (sheet 1) a botton or control to create a new sheet (in the same workbook) and named for their lastname individually. in which in their own sheet having their own details from sheet 1. for which i could add another data (later) in their own (named) sheet.
would appreciate for any reply......
thank you...
im a school registrar, could someone teach me how to put macro on my worksheet:
1. encoded a rows of student details (e.g. First Name, Middle Name, Last Name, age, sex etc.) in sheet 1.
2. in the same sheet (sheet 1) a botton or control to create a new sheet (in the same workbook) and named for their lastname individually. in which in their own sheet having their own details from sheet 1. for which i could add another data (later) in their own (named) sheet.
would appreciate for any reply......
thank you...
