Hi, I am a teacher and I have a spreadsheet to monitor behaviour. I would
like it to go one step further though... but it may be impossible!?
I currently have a sheet with my pupils names down one side. In the cells
next to the names I am using a double-click event to ut a x, xx, or 15 into
the cells to denote level of warnings received. at the very top of this
column I have a doubleclick event to put in the current date.
Now.... What I would like is for when a pupils reaches 15 for it to be
pasted into a new sheet where I can note when the detention is due. I would
then like this to happen for other pupils that receive "15" and for it to
make a list as it were with dates they received the 15.
Is this possible? If so.... Thank you thank you thank you!!!
PS. I have an example of the spreadsheet if needed.
Bookmarks