Pantherlucky
New Member
- Joined
- Oct 31, 2020
- Messages
- 6
- Office Version
- 365
- Platform
- Windows
Hello! I need to create a macro to create a message box which will contain the names and the grades of 8 different candidates. These values are located in a different worksheet (Sheet 2). For the first 2 candidates the message must be "*insert name of candidate here* is accepted to Department A with a grade of *insert grade here*". For the next 2 the message must be "*insert name of candidate here* is accepted to Department B with a grade of *insert grade here*". For the next candidate the message is "*insert name of candidate here* is accepted to Department C with a grade of *insert grade here*". Finally for the last three candidates the message must be " *insert name of candidate here* is a back up candidate*". The two columns which are used for this are, as i mentioned, in Sheet2 and are sorted in a descending order ( top to lowest grade). The A column contains the name of the candidates whilst the B column contains their respective grades. Any help would be greatly appreciated!