+ Reply to Thread
Results 1 to 7 of 7

Attendance Tracker

  1. #1
    Registered User
    Join Date
    02-18-2011
    Location
    Kent, WA
    MS-Off Ver
    Excel 2010
    Posts
    15

    Attendance Tracker

    Sheet1
    A1 Rolando
    A2 Koki
    A3 RU
    A4 JF Balmore
    A5 Big Pun
    A6 Juan Pablo
    A7 Herminio

    Sheet2
    A1 Geovanny
    A2 Fernando R.
    A3 Koki
    A4 Saravia
    A5 JF Edwin
    A6 Rolando
    A7 William

    Sheet3
    A1 Koki
    A2 Saravia
    A3 JF Edwin
    A4 JF Balmore
    A5 Santos
    A6 Eduardo
    A7 Uriel
    I am trying to keep an attendance record of how many days our drivers work. Since the names will always change slot i was wondering if there was a way to have on the 4th how many days they have worked without having to manually put in the numbers. Like if Uriel worked one day the next row it would have 1 next to Uriel, but if i were to go go to sheet 1 and put his name there then on sheet 4 it would pop up Uriel 2

    Sheet4
    A2 Rolando
    A3 Koki
    A4 RU
    A5 JF Balmore
    A6 JF Edwin
    A7 Big Pun
    A8 Juan Pablo
    A9 Herminio
    A10 Geovanny
    A11 Fernando R.
    A12 Saravia
    A13 William
    A14 Santos
    A15 Eduard
    A16 Uriel

  2. #2
    Forum Contributor TechRetard's Avatar
    Join Date
    06-14-2009
    Location
    Houston, TX
    MS-Off Ver
    Excel 2010
    Posts
    202

    Re: Attendance Tracker

    How many sheets will you have..one for each day of the week?

    Will you just have 3 sheets with the fourth being a template?

    next to each name on the summary sheet you could have a formula like
    Please Login or Register  to view this content.
    where A1 was the person's name... does that make sense?

  3. #3
    Registered User
    Join Date
    02-18-2011
    Location
    Kent, WA
    MS-Off Ver
    Excel 2010
    Posts
    15

    Re: Attendance Tracker

    It is one sheet per day and each file covers one month. yes it does thank you. When i input the code as a test trial it just comes up 0. I got it thank you very much
    Last edited by Jrios; 02-19-2011 at 02:17 PM.

  4. #4
    Registered User
    Join Date
    02-18-2011
    Location
    Kent, WA
    MS-Off Ver
    Excel 2010
    Posts
    15

    Re: Attendance Tracker

    each sheets name is as follows FEB.1-11 FEB.2-11 FEB.3-11 what would i put in place of sheet1. I put FEB.1-11 and i just get an error

  5. #5
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: Attendance Tracker

    Did you place single quotes, like this:

    'FEB. 1-11'!

  6. #6
    Registered User
    Join Date
    02-18-2011
    Location
    Kent, WA
    MS-Off Ver
    Excel 2010
    Posts
    15

    Re: Attendance Tracker

    fixed it thank you again

  7. #7
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,015

    Re: Attendance Tracker

    Hi Jrios,
    If you were to put your day sheets information all on the same sheet, you could do a lot more with the data.
    See the attached example with 3 different pivot tables that are non-formula answers to your attendence problem.
    Hope this gives you some other ideas on how to do attendence.
    Attached Files Attached Files
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1