How do I create an subroutine, which will examine my first sheet Grade column (consists of Pass, Merit, Distinciton and FaiL) and put the total number of pass, fail, merit and distinction on the relevant cells of the 2nd worksheet.
Any help would be much appreciated!!