TimExcel123
New Member
- Joined
- May 30, 2019
- Messages
- 2
Hi guys,
My name is Tim and I am new to this Forum.
I experience a lot of trouble while designing my first code in Excel VBA. The problem is as following: in column B(worksheet 1), I inserted the names of some students. in column C, I inserted the marks of the corresponding students (see table 1).
In worksheet 2 table 2, I want cells A1:A3 to display the names of the 3 best students. After watching a lot of Youtube-tutorials, I still did not manage tot figure out how to do it. Is there anyone who could help me designing this code in VBA?
Thanks in advance!
-------------------------------------------------------
Table 1 worksheet 1:
<tbody>
</tbody>
table 2 worksheet 2:
<tbody>
</tbody>
My name is Tim and I am new to this Forum.
I experience a lot of trouble while designing my first code in Excel VBA. The problem is as following: in column B(worksheet 1), I inserted the names of some students. in column C, I inserted the marks of the corresponding students (see table 1).
In worksheet 2 table 2, I want cells A1:A3 to display the names of the 3 best students. After watching a lot of Youtube-tutorials, I still did not manage tot figure out how to do it. Is there anyone who could help me designing this code in VBA?
Thanks in advance!
-------------------------------------------------------
Table 1 worksheet 1:
Student | Mark |
Alex | 9,5 |
Sophie | 7 |
Nick | 8 |
Paul | 4 |
Helena | 9 |
jan | 6 |
<tbody>
</tbody>
table 2 worksheet 2:
Best students |
? |
? |
? |
<tbody>
</tbody>