I have a spreadsheet that has 3 sheets - the 1st sheet lists all the employee names and how many points they have; the 2nd sheet shows their names (which it pulls from the 1st sheet), shows the total points but also has a calendar from 1/1/15 to 12/31/15 and the 3rd sheet is just for data. On the 2nd sheet, the purpose is to record if someone calls in, is late or leaves early. If they call in it's 2 points and 1 point for leaving early or coming in late, which is calculated on the 2nd sheet.
I've been trying to get some help and was told VBA would be my best bet. What I want to happen is that, after 1 pay period (14 days) if a person doesn't call in, isn't late or doesn't leave early, they get 2 points back. They can go as low as -5 points, essentially "banking" points until they call in, are late or leave early.
I've attached a copy of my current spreadsheet, I just can't figure out a formula that would make it so that after every "pay day" (or 2 week period), the spreadsheet would check and see if people called in or not and then if they didn't, it'd give them all 2 points back up to -5 points.
Anyone have any thoughts or suggestions?
Here's my spreadsheet:
attendancetracker.xlsx
Bookmarks