LarryLaser
10-08-2006, 09:19 PM
Is it possible to make all cells in a single spreadsheet as check box's?
Details;
WorkBook designed as a Grade Book with the first Sheet as an Attendance Sheet, each cell represents a single day with "check" for present and "NO check" for absence. In other words, Boolean (true or false).
If so, can a function be applied to each cell, so when you are in an active cell you type "Y" for present (check mark) or "N" for absent (no check mark) and return/enter is automatic (moves to next row/cell below).
At the end of a period (9 weeks) use the data from each sheet (Including attendance) to create a Chart / Report for each student (parent eval).
Details;
WorkBook designed as a Grade Book with the first Sheet as an Attendance Sheet, each cell represents a single day with "check" for present and "NO check" for absence. In other words, Boolean (true or false).
If so, can a function be applied to each cell, so when you are in an active cell you type "Y" for present (check mark) or "N" for absent (no check mark) and return/enter is automatic (moves to next row/cell below).
At the end of a period (9 weeks) use the data from each sheet (Including attendance) to create a Chart / Report for each student (parent eval).