• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Rolling 6 months

D

drewszone32

Member
I am looking to put together an excel sheet to track attendance points throughout the year as a rolling 6 months. Simply excel sheet with Name in column A and Points in column G with Date in column F. Information will continue to be added to sheet. Can someone help me out?
 
Will the information be added manualy ? because than you could just make a simple excel table. or you could make a userform to input the data
 
It will be pulled out of timekeeping and copy and pasted in excel form. Basically a running tally and when the 6 month date comes up then a point is taken off employee. exp. point on January 1st and 6 months later point is taken off to keep track of employees points.
 
hmm oke, you can connect a excel file to a database. go to data tab, but you need to know if the software is supporting this. In excel you can make a function that keeps track of the 6 month and after that i will give you a wrap up of all the points collected for every user etc etc.
 
You must log in or register to reply here.
Back
Top