PC Review


Reply
Thread Tools Rate Thread

attendance sheet

 
 
Lynn
Guest
Posts: n/a
 
      14th Jul 2009
I need to mark attendance for a class running for 3 months.
anyone an attendance sheet for 15 people where i can just check on
each box if they are present.

this should also have a pie chart where each person's participation is
shown as a percentage to all
 
Reply With Quote
 
 
 
 
Bob Phillips
Guest
Posts: n/a
 
      14th Jul 2009
Put the names in A2 down, the dates in B1 across to say CO1, and then

This works by double-clicking in a cell, and toggles the check-mark.

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
Const WS_RANGE As String = "B2:CO16" '<=== change to suit

On Error GoTo err_handler
Application.EnableEvents = False
If Not Application.Intersect(Target, Range(WS_RANGE)) Is Nothing Then
With Target
.Font.Name = "Marlett"
Select Case .Value
Case "": .Value = "a"
Case "a": .Value = ""
End Select
End With
End If
err_handler:
Application.EnableEvents = True
End Sub


This is worksheet event code, which means that it needs to be
placed in the appropriate worksheet code module, not a standard
code module. To do this, right-click on the sheet tab, select
the View Code option from the menu, and paste the code in.

then just chart that data.

--
__________________________________
HTH

Bob

"Lynn" <(E-Mail Removed)> wrote in message
news:7618a151-1531-4308-a8b9-(E-Mail Removed)...
>I need to mark attendance for a class running for 3 months.
> anyone an attendance sheet for 15 people where i can just check on
> each box if they are present.
>
> this should also have a pie chart where each person's participation is
> shown as a percentage to all



 
Reply With Quote
 
john
Guest
Posts: n/a
 
      14th Jul 2009
There are some free templates you can download from this site which may be of
some help to you.

http://www.vertex42.com/ExcelTemplat...-tracking.html
--
jb


"Lynn" wrote:

> I need to mark attendance for a class running for 3 months.
> anyone an attendance sheet for 15 people where i can just check on
> each box if they are present.
>
> this should also have a pie chart where each person's participation is
> shown as a percentage to all
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Attendance Sheet. =?Utf-8?B?Q2xhcms=?= Microsoft Excel Misc 2 18th Oct 2007 03:20 AM
Re: Help with Volunteer Attendance Sheet Bob Phillips Microsoft Excel Misc 0 16th Dec 2005 09:44 AM
Attendance Sheet in Access dennishancy@eaton.com Microsoft Access 3 8th Nov 2005 06:06 PM
attendance sheet =?Utf-8?B?bWF5IEhT?= Microsoft Excel Worksheet Functions 1 12th Sep 2005 06:49 PM
attendance sheet to add time but not..... Betty Rides 04 Microsoft Excel Worksheet Functions 1 23rd Mar 2005 04:11 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:35 PM.