santosh_singh83
New Member
- Joined
- May 2, 2022
- Messages
- 1
- Office Version
- 2010
- Platform
- Windows
hello everyone,
i am very new in writing VBA Macros in Excel .earlier i use to do my work using formulas .
i am trying to prepare a grade sheet in format from collecting data from multiple sheets . i have sheet th for theory marks , practical for practical marks , reappear sheet for candidate who fail and back paper candidates previous mark sheet and Co Sheet in which i want the output . th sheet has duplicate values because candidate has 2 theory papers with different dates in same rows.
TH Sheet
Co Sheet
i want to get the theory 1 and theory 2 marks of th sheet in to Co sheet as per format . trying to s so but failed to do
requested to guide and help .
i am very new in writing VBA Macros in Excel .earlier i use to do my work using formulas .
i am trying to prepare a grade sheet in format from collecting data from multiple sheets . i have sheet th for theory marks , practical for practical marks , reappear sheet for candidate who fail and back paper candidates previous mark sheet and Co Sheet in which i want the output . th sheet has duplicate values because candidate has 2 theory papers with different dates in same rows.
TH Sheet
| macro_gradesheet.xlsm | |||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | |||
| 1 | s no | (*)Registration_number | (*)Roll Number | (*)Name of the Candidate | (*)Father Name | (*)Mother Name | (*)Guardian Name | (*)Sex | (*)Date Of Birth | (*)EmailID | (*)Contact Number | (*)Examination Centre Name | (*)Examination Centre Address | Domain Name | Test Name | exam Date | Questions Attempted | No of Correct Attempts | Theory Result | ||
| 2 | 1 | 1457303 | SNE0052202000001 | TANVEERA AKHTER | MOHD SHAFI CHOHAN | RAFEEQA BEGUM | NA | FEMALE | 16-02-2001 | mtechtechnologies786@gmail.com | 9622433295 | HR institute ,Chandilora Tangmarg Baramulla | HR institute ,Chandilora Tangmarg Baramulla | NSQF | Diploma in Installation and Repair of Consumer Electronics Products Theory-1 | 16-02-2022 | 100 | 63 | PASS | ||
| 3 | 2 | 1457303 | SNE0052202000001 | TANVEERA AKHTER | MOHD SHAFI CHOHAN | RAFEEQA BEGUM | NA | FEMALE | 16-02-2001 | mtechtechnologies786@gmail.com | 9622433295 | HR institute ,Chandilora Tangmarg Baramulla | HR institute ,Chandilora Tangmarg Baramulla | NSQF | Diploma in Installation and Repair of Consumer Electronics Products Theory-2 | 17-02-2022 | 100 | 50 | PASS | ||
| 4 | 3 | 1457304 | SNE0052202000002 | RIFAT ARA | SHEER AHMAD CHOHAN | HAMEEDA | NA | FEMALE | 02-02-2001 | mtechtechnologies786@gmail.com | 9622433295 | HR institute ,Chandilora Tangmarg Baramulla | HR institute ,Chandilora Tangmarg Baramulla | NSQF | Diploma in Installation and Repair of Consumer Electronics Products Theory-1 | 16-02-2022 | 100 | 55 | PASS | ||
| 5 | 4 | 1457304 | SNE0052202000002 | RIFAT ARA | SHEER AHMAD CHOHAN | HAMEEDA | NA | FEMALE | 02-02-2001 | mtechtechnologies786@gmail.com | 9622433295 | HR institute ,Chandilora Tangmarg Baramulla | HR institute ,Chandilora Tangmarg Baramulla | NSQF | Diploma in Installation and Repair of Consumer Electronics Products Theory-2 | 17-02-2022 | 100 | 47 | FAIL | ||
| 6 | 5 | 1457305 | SNE0052202000003 | SAFEENA AKHTER | SHAMMAS UD DINGAIGY | NAZIRA BANO | NA | FEMALE | 10-02-2001 | mtechtechnologies786@gmail.com | 9622433295 | HR institute ,Chandilora Tangmarg Baramulla | HR institute ,Chandilora Tangmarg Baramulla | NSQF | Diploma in Installation and Repair of Consumer Electronics Products Theory-1 | 16-02-2022 | 100 | 62 | PASS | ||
| 7 | 6 | 1457305 | SNE0052202000003 | SAFEENA AKHTER | SHAMMAS UD DINGAIGY | NAZIRA BANO | NA | FEMALE | 10-02-2001 | mtechtechnologies786@gmail.com | 9622433295 | HR institute ,Chandilora Tangmarg Baramulla | HR institute ,Chandilora Tangmarg Baramulla | NSQF | Diploma in Installation and Repair of Consumer Electronics Products Theory-2 | 17-02-2022 | 100 | 48 | FAIL | ||
| 8 | 7 | 1457306 | SNE0052202000004 | IQBAL AHMAD BOMOLA | RAFIQ AHMAD BOMOLA | NASEEMA | NA | MALE | 03-12-2001 | mtechtechnologies786@gmail.com | 9622433295 | HR institute ,Chandilora Tangmarg Baramulla | HR institute ,Chandilora Tangmarg Baramulla | NSQF | Diploma in Installation and Repair of Consumer Electronics Products Theory-1 | 16-02-2022 | 100 | 67 | PASS | ||
| 9 | 8 | 1457306 | SNE0052202000004 | IQBAL AHMAD BOMOLA | RAFIQ AHMAD BOMOLA | NASEEMA | NA | MALE | 03-12-2001 | mtechtechnologies786@gmail.com | 9622433295 | HR institute ,Chandilora Tangmarg Baramulla | HR institute ,Chandilora Tangmarg Baramulla | NSQF | Diploma in Installation and Repair of Consumer Electronics Products Theory-2 | 17-02-2022 | 100 | 59 | PASS | ||
| 10 | 9 | 1457307 | SNE0052202000005 | ZAHIDA PARVEEN | MOHAMMAD RAFEEQ CHACHI | NOOR JAN | NA | FEMALE | 02-02-1998 | mtechtechnologies786@gmail.com | 9622433295 | HR institute ,Chandilora Tangmarg Baramulla | HR institute ,Chandilora Tangmarg Baramulla | NSQF | Diploma in Installation and Repair of Consumer Electronics Products Theory-1 | 16-02-2022 | 100 | 64 | PASS | ||
| 11 | 10 | 1457307 | SNE0052202000005 | ZAHIDA PARVEEN | MOHAMMAD RAFEEQ CHACHI | NOOR JAN | NA | FEMALE | 02-02-1998 | mtechtechnologies786@gmail.com | 9622433295 | HR institute ,Chandilora Tangmarg Baramulla | HR institute ,Chandilora Tangmarg Baramulla | NSQF | Diploma in Installation and Repair of Consumer Electronics Products Theory-2 | 17-02-2022 | 100 | 50 | PASS | ||
| 12 | 11 | 1457308 | SNE0052202000006 | BASHARAT AHMAD GEEGI | BASHIR AHMAD GEEGI | FAREEDA BEGUM | NA | MALE | 01-01-2005 | mtechtechnologies786@gmail.com | 9622433295 | HR institute ,Chandilora Tangmarg Baramulla | HR institute ,Chandilora Tangmarg Baramulla | NSQF | Diploma in Installation and Repair of Consumer Electronics Products Theory-1 | 16-02-2022 | -1 | -1 | ABSENT | ||
th | |||||||||||||||||||||
Co Sheet
| macro_gradesheet.xlsm | |||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | |||
| 10 | Sno | Roll No | Reg.No. | Name of the Candidate | Father Name | Domain Name | Test Name | DOB | Theory 1 (100) | Theory 2 (100) | Practical (90) | Internal Assement (30) | Assignment (30) | Overall Total (350) | Percentage | Overall Result (Grade) | |||||||||
| 11 | (1) | (2) | (3) | (4) | (5) | ||||||||||||||||||||
| 12 | Exam Date | Marks Secured | Result | Exam Date | Marks Secured | Result | Marks Secured | Result | Marks Secured | Result | Marks Secured | Result | |||||||||||||
| 13 | SNE0052202000001 | 1457303 | TANVEERA AKHTER | MOHD SHAFI CHOHAN | NSQF | ||||||||||||||||||||
| 14 | SNE0052202000002 | 1457304 | RIFAT ARA | SHEER AHMAD CHOHAN | NSQF | ||||||||||||||||||||
| 15 | SNE0052202000003 | 1457305 | SAFEENA AKHTER | SHAMMAS UD DINGAIGY | NSQF | ||||||||||||||||||||
| 16 | SNE0052202000004 | 1457306 | IQBAL AHMAD BOMOLA | RAFIQ AHMAD BOMOLA | NSQF | ||||||||||||||||||||
| 17 | SNE0052202000005 | 1457307 | ZAHIDA PARVEEN | MOHAMMAD RAFEEQ CHACHI | NSQF | ||||||||||||||||||||
| 18 | SNE0052202000006 | 1457308 | BASHARAT AHMAD GEEGI | BASHIR AHMAD GEEGI | NSQF | ||||||||||||||||||||
| 19 | SNE0052202000007 | 1457309 | IQRA HANEEF | MOHAMMAD HANEEF DEEDAD | NSQF | ||||||||||||||||||||
co | |||||||||||||||||||||||||
i want to get the theory 1 and theory 2 marks of th sheet in to Co sheet as per format . trying to s so but failed to do
requested to guide and help .
