Here are the steps:
1. In Sheet 1 column A3, B3, C3, and D3 type the following column name: Name of students, Subject, Grade, and Remarks.
2. Use Relative Reference to start record the name of students. Change the name macro to Listofmystudents.
3. Here are the list of names to record under the Name of students:
|
4. Then click to Stop Recording.
5. Now, you can run your relative macros somewhere in your sheets anywhere the cells is active.
6. Under Subject column. Use Relative Reference to start record the student subject and name it Studentsubjects. Then type the following Subject.
Math
|
English
|
Programming
|
Science
|
English
|
Math
|
Programming
|
English
|
Science
|
Math
|
7. Then click to Stop Recording.
8. Now, you can run your relative macros somewhere in your sheets anywhere the cells is active.
9. Under the Grade column. Again, use Relative Reference to start record the student grade and name it Studentgrade. Then type the following Grade.
90
|
74
|
85
|
71
|
96
|
80
|
91
|
70
|
89
|
72
|
10. Then click to Stop Recording.
11. Now, you can run your relative macros somewhere in your sheets anywhere the cells is active.
To create a Remarks, we want to record again using if statement. The purposed is, if you want to determine either the student’s Passed or Failed just simply run the macros, automatically the macros filled the remarks.
1. Under Remarks column. Again, use Relative Reference to start record the student remarks and name it Studentsremarks. Then type the following formula.
2. =IF(C4<75,"Failed","Passed") in D4 under Remarks column
3. Then click to Stop Recording.
4. Now, you can run your relative macros somewhere in your sheets anywhere the cells is active.
You can create your own layout separated on your actual work using macros and run it if needed.
HOW?
1. In Sheet 2, run your macros name: Listofmystudents in C5, Studentsubjects in D5, Studentgrade in E5, and Studentsremarks in F5. Expand the width of each column that fit to your data.
2. Now, we want to record our layout. Again, use relative reference to start record and name it Fillmyownlayout.
3. Layout your own design, then click to Stop Recording if already done.
4. Now, you can select the name of your Relative Macros to run somewhere in your Sheets anywhere the cells is active.
0 comments:
Post a Comment