Hi
I wonder if anyone can give me some guidance. I need to create an excel program that will allow me to keep track of "house points" in a school. The idea is that there are 3 houses and as pupils earn points, I want staff to be able to access the program via the server and add points in a cumulative sense. All I want are three totals under the names of the houses and a space to add points - but I don't want the values added to be visible after they are entered. I.e. once you've entered 10 points, the cell then returns to a blank cell, but the total of points for the house increases. I'm not sure how to do this. If anyone could suggest a way or recommend a better suggestion, it would be most appreciated.
I'm hoping to link the totals to a bar graph to make it easy for the pupils to see who is winning!
Thanks very much!
Bookmarks