Hey guys I'm trying to use a spreadsheet that will accumulate points. Right now I have a table on the left that will have the member's name and the type and on the right I have the place where they would enter their values. So I have a couple of questions.
1. How would I go about making a default entry in the list, for example, the first time the user opens up the program, the list has already selected an entry by default.
2. How would I separate a value from it's cell. Right now the entries on the right would be used by other people, for example, if I calculated the points to be 2.5, for one person, how would I make it so that 2.5 points stay for that person even if the next person alters the entries for her own use?
3. Is there a way I can make the table where the results are being shown to shift to the next row, and start there? For example, once the results are calculated, they would be entered into A2, and the next time someone enters and it calculates the result, it will be entered into B2, etc etc.
Thanks in Advance
Bookmarks