VBA to convert cell contents to comments.

[sjp1979]

Hi All

I have a sheet that counts the number of people that fulfil requirements on another sheet and displays the number. i.e. it counts students who have a target grade of B, who have achieved a C and are in class 10r1.

The sheet containing the data is called 'data' the target is in column D, their achieved grade is in column R and their class number is in column E.

The formula I have used to do this is =COUNTIFS(Data!AC:AC,"=B",Data!R:R,"=C",Data!E:E,"=10r1")

What I would like is for the box with the count in it to also display the names (column C) of the students that have been counted in it's comments when you mouseover - The comment in the cell needs to contain the names of the students who provided a positive result for the count, itself.

I know this is possible as I've seen it done by another school. However, their spreadsheet was locked so i couldn't see the code.

Thanks in advance.

Stephen

 

[sjp1979]

If there is another way I can do something similar and just bring up a list in the sheet, that would be fine too. If it was in the comments it would look neater but a simple list within the sheet would be fine too.