+ Reply to Thread
Results 1 to 2 of 2

Need help with creating an attendance tracker.

  1. #1
    Registered User
    Join Date
    02-25-2014
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    1

    Need help with creating an attendance tracker.

    Hello i am needing some help with creating a worksheet that is able to track attendance and display the most recent number of consecutive days absent.

    It would have two sheets, one that would display a list of names and then next to them display number of hours missed and most recent consecutive days missed. The second would have dates along the top of the sheet and then the persons name and whether or not they were there at the beginning and end of the day in question.

    The second sheet would be filled out everyday as to whether people had attended or not during role call.

    Here is an idea of what i am looking for.

    sheet 1.png

    sheet 2.png

    Sheet 1 would automatically update any time changes would be made to sheet 2 so if all five people were marked as being here both at the beginning and end of the next day (2/26/2014) sheet 1 would say that none of the hours had changed but all of the consecutive days would reset to 0.

    I'm not sure on how to do this or if it is even possible to do in excel, my experience is limited to very basic functions so any help would be appreciated. if you need any more information for this let me know I have been struggling with this for weeks now.

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Need help with creating an attendance tracker.

    To help others help you, click on GO ADVANCED and use the paperclip icon to attach an actual workbook. Make sure you mock up some sample "results" manually in the workbook and point out those cells are the ones you're trying to automate.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Creating a Dynamic Attendance Tracker with Additional Data Items
    By Caleb952 in forum Excel General
    Replies: 3
    Last Post: 01-12-2013, 01:41 AM
  2. [SOLVED] Attendance Tracker
    By rajeshntiwari in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-03-2012, 04:07 PM
  3. Attendance Tracker
    By Jrios in forum Excel General
    Replies: 6
    Last Post: 02-19-2011, 03:44 PM
  4. Attendance Tracker,
    By excelkeechak in forum Excel General
    Replies: 8
    Last Post: 05-11-2010, 08:59 PM
  5. Attendance Tracker
    By shanny in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-06-2008, 08:44 AM

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