Andrew1995
New Member
- Joined
- Jan 16, 2020
- Messages
- 3
- Office Version
- 2016
- Platform
- Windows
Dear friends
i am in need of some help. i am quite new and learning. i have done some work on it but dont know how to continue now. So basically i have a ''master'' called sheet that has a list of students from A6 TO A36 and their student ids from B6 to B36 and from C6 to C36 to have their unique password. the columns D E and going on have there subjects and grades. so what i want to do is as follows:
1) After i add the details of the students and their grades, all their details to be copied to a new sheet for each student in a new workbook automatically as in the example below. (one workbook with new sheet for every student) i will attach the master sheet and a new student sheet for example purposes.
2)After the new workbook is created i want when i open it to have all the details hidden and a search box to appear directly. each student must add their unique id and there unique password to show their sheet only and to not have any other options to do.
i am in need of some help. i am quite new and learning. i have done some work on it but dont know how to continue now. So basically i have a ''master'' called sheet that has a list of students from A6 TO A36 and their student ids from B6 to B36 and from C6 to C36 to have their unique password. the columns D E and going on have there subjects and grades. so what i want to do is as follows:
1) After i add the details of the students and their grades, all their details to be copied to a new sheet for each student in a new workbook automatically as in the example below. (one workbook with new sheet for every student) i will attach the master sheet and a new student sheet for example purposes.
2)After the new workbook is created i want when i open it to have all the details hidden and a search box to appear directly. each student must add their unique id and there unique password to show their sheet only and to not have any other options to do.