Hi

I am developing a workbook, one part of the book is to track discipline I have a page for this and a userform on the front page to enter data into it. I would like if you will a summary box (list box or whatever is best) displayed on the front page and I would like a line to appear in that box maybe saying john smith requires a warning. I need this to appear if john smith has been entered 3 times into the name column on the discipline sheet however only if the offence is the same 3 times for example 3 lates not 2 lates and 1 non attendance.

After it displays this line in the summary box I would like to be able to double click it where a small userform appears where a user can then select discipline received or something and for this lien to disappear in the summary and all 3 entries in the discipline sheet.

Sorry its lengthy, any more info or a small example can be uploaded if needed.

Thanks in advance
Dan