+ Reply to Thread
Results 1 to 9 of 9

Simplest way for attendance/point tracking in Excel?

  1. #1
    Registered User
    Join Date
    06-03-2015
    Location
    South
    MS-Off Ver
    Excel 2010
    Posts
    6

    Simplest way for attendance/point tracking in Excel?

    A simple point tracking system for attendance. I've seen before that a lot of times someone will help someone out with a spreadsheet. Would anyone be willing to help.
    What is the easiest way to do this. Points reset at the end of the calendar year. This tracking system/excel will be done by scratch

  2. #2
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: Simplest way for attendance/point tracking in Excel?

    Have you looked at this post......
    http://www.excelforum.com/excel-form...-tracking.html
    1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
    You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.

    Tom

  3. #3
    Registered User
    Join Date
    06-03-2015
    Location
    South
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Simplest way for attendance/point tracking in Excel?

    I have. Thank you for your post. I don't know much about excel at this point so I'm trying to do something simple from scratch.
    The points will accrue as follows
    .5
    1
    2
    I just need a system to use that is simple enough to use for the remainder of the year

  4. #4
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: Simplest way for attendance/point tracking in Excel?

    The code in that post does have the points for .5, but not 1 or 2. You say you are looking for something "simple", I'm not sure that what your wanting to do has a "simple" solution. Then again, I don't know much about code for point tracking so I could be way wrong with my theory/suggestions.

  5. #5
    Registered User
    Join Date
    06-03-2015
    Location
    South
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Simplest way for attendance/point tracking in Excel?

    I'll be honest. I have no idea what that code means at all, or what to even do with that information

  6. #6
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: Simplest way for attendance/point tracking in Excel?

    Did you download and look at the attachment in the link I posted?

  7. #7
    Registered User
    Join Date
    06-03-2015
    Location
    South
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Simplest way for attendance/point tracking in Excel?

    Yes sir, I did. It looks like a really clean system and something I could possibly figure out. I have a very silly question, how do I set this exact system up? Is that code supposed to be copy/pasted? I really don't know much at all about excel besides manually entering data, sadly.

  8. #8
    Registered User
    Join Date
    06-03-2015
    Location
    South
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Simplest way for attendance/point tracking in Excel?

    Quote Originally Posted by gmr4evr1 View Post
    Did you download and look at the attachment in the link I posted?
    Would you mind if I pm'd you what I have so far? I have the spreadsheet set-up but the 'data validation' isn't right. I'm having to manually enter in every bit of data

  9. #9
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: Simplest way for attendance/point tracking in Excel?

    Sure you can.

+ 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. Replies: 10
    Last Post: 03-17-2016, 05:34 AM
  2. Need Help Rolling 6/12 Month Attendance Point Tracking
    By khintze in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-06-2015, 05:46 PM
  3. Attendance Point Tracking Worksheet, need some help with finishing touches.
    By SRWilson87 in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 01-13-2015, 04:24 PM
  4. Employee Attendance Point Tracking
    By mwade3434 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-07-2014, 04:27 PM
  5. Choice of application (Excel or Access) for attendance tracking
    By Ramzess in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-05-2011, 03:52 PM

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