You said “I need a calendar that, each day, will sum attendance data “

Calendars don’t “sum” anything. Calendars show dates, days, appointments, etc.

Do you mean you need a list such as this?

         A                          B
1     1/1/2014        {Sum of data from 11/2/2013}
2     1/2/2014        {Sum of data from 11/3/2013}
3     1/3/2014        {Sum of data from 11/4/2013}

If that is what you are looking for, we’ll need some details as to where the data to be summed will be found.

Click Here Before Posting Data or VBA Code —> How To Post Data or Code.

The Worksheet_Change event fires whenever a change is made to the worksheet in which it resides.

A Worksheet_Change event looks something like this:

Private Sub Worksheet_Change(ByVal Target As Range)
 If Target.Address = "$B$2" Then
   MsgBox "Cell B2 Was Changed!"
 End If
End Sub

Obviously you would change the MsgBox instruction to show your Form Control.

To check for different values in B2, you would use more If’s:

Private Sub Worksheet_Change(ByVal Target As Range)
 If Target.Address = "$B$2" Then
 
   If Target = "Apple" Then
    MsgBox "B2 Now Shows Apple"
   End If
   
    If Target = "Grape" Then
    MsgBox "B2 Now Shows Grape"
   End If
   
 End If
End Sub

I hope that helps.

Click Here Before Posting Data or VBA Code —> How To Post Data or Code.

You are going to have to make some changes at home before you’ll be able to make the VoIP phone work.
You metion having a 2wire device. This will be a “combo” unit that is a modem/router/wireless AP all wrapped up in one device. If I’m correct, you’ll only ever be able to daisychain your second router to the 2wire.

I’ve never played with VoIP at home so I know nothing about that side of it (but I know all about the Enterprise side of VoIP because we use it at work) but if wanderer is right, then your VoIP probably still won’t work even if you have it plugged into the 2wire with a network cable.

From the sounds of it, the router you got from your company needs to be the unit connected directly to the internet.

If this is true, you need to get a modem that is nothing else but a modem. Then you would plug your company supplied router into it.

Since you’re using ADSL, I suspect you have phone outlets all over your house. There’s nothing stopping you from plugging your ADSL modem in upstairs where you need the VoIP phone. Then, plug your company supplied router into it. You could then bridge the 2wire device to that router and set it up downstairs and connect your PC down there to it.

This solves all your problems but is dependent on you getting a modem from your ISP that isn’t a combo unit. Some ISP’s, like mine, supply that equipment. Other’s charge the customer for it. With luck, your ISP is like mine. If not, you might be able to claim it as an expense at work and have your company pay for it since it will be required to make the VoIP phone work.