+ Reply to Thread
Results 1 to 5 of 5

Need help for creating a system to track attendance

  1. #1
    Registered User
    Join Date
    12-15-2015
    Location
    Oregon, United states of America
    MS-Off Ver
    WPS spreadsheets
    Posts
    2

    Need help for creating a system to track attendance

    Basically, I was working on a system where a person's name is inserted to a cell or a box of some sort. Now, there's already a list of all the names, and cells for how many days they have attended. Basically, I just want to know if it's possible to make a system where I insert the name, which adds a value to the person's attendance cell, and then the name is deleted without taking the just added value from the cell. Please point me in the right direction.

  2. #2
    Valued Forum Contributor
    Join Date
    08-07-2014
    Location
    Quito, Ecuador
    MS-Off Ver
    Excel 2016 & 365, Windows 10
    Posts
    511

    Re: Need help for creating a system to track attendance

    Now, there's already a list of all the names, and cells for how many days they have attended.
    Basically, I just want to know if it's possible to make a system where I insert the name, which adds a value to the person's attendance cell,
    Up to this point, the statement is clear, and easy to solve....but

    then the name is deleted without taking the just added value from the cell.
    this is a bit confusing, I can't get your point
    could you explain better?
    Barriers are there for those who don't want to dream

  3. #3
    Registered User
    Join Date
    10-26-2015
    Location
    Belgium
    MS-Off Ver
    2013
    Posts
    36

    Re: Need help for creating a system to track attendance

    I think he means to clear the "input box" without deleting the value that is added to the cells. so lets say he has 5 names

    name1
    name2
    name3
    name4
    name5

    if he enters name1 in cell A1, add 5 to attendance of name1
    if he enters name2 in cell a1, add 5 to attendance of name2

    I'll try making a working workbook to use

  4. #4
    Registered User
    Join Date
    12-15-2015
    Location
    Oregon, United states of America
    MS-Off Ver
    WPS spreadsheets
    Posts
    2

    Re: Need help for creating a system to track attendance

    Yeah, what stielo meant. Sorry if it was confusing! Also thank you Stielo for attempting to solve my problem.

  5. #5
    Registered User
    Join Date
    10-26-2015
    Location
    Belgium
    MS-Off Ver
    2013
    Posts
    36

    Re: Need help for creating a system to track attendance

    attendance.xlsm
    Hi Mark,
    I have attached a workbook that should do what you asked.
    It compares the name you insert in the textbox (after clicking attendance) and if you type the name and it matches, it will add 1 to the value of the column (attendance).

    I think this is what you needed?

    Also, you can just write new names (or copy them) from your workbook and it should compare them.
    I must tell you though, if the workbook is very long (like 500 names or so) it might take a while, as the code i used loops every used row in column A.

    Hope it's good enough . and if it solved, please add rep (star on bottom left corner of my post) and mark your thread as solved.

+ 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. Track Employee Attendance
    By maabbas in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-17-2015, 08:17 AM
  3. Need help to track attendance
    By shaikfazil in forum Excel General
    Replies: 1
    Last Post: 03-04-2015, 01:21 AM
  4. Need help to track attendance
    By shaikfazil in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-03-2015, 06:13 PM
  5. Keeping track of attendance point system
    By okracerx in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-30-2013, 11:08 PM
  6. Excel Macro for creating Attendance rerort when executive login in the system
    By medhekaraniruddha in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-14-2012, 08:39 AM
  7. How can I track meeting attendance?
    By craezer in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 02-18-2006, 07:30 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