I currently have a spreadsheet that is used as a check in/out board at work. Attaching a small sample of it. What I want to do is for all persons that are currently checked in thru a dropdown box, and forget to check out at the end of the day, a macro could be set up to run and reset all of the check in to checkout's, but leaving all other dropdown choices alone, including vacation, sick, etc. Ideally, would like this to automatically work from a given system time such as 11:59 PM, and would like this to work weather the file is open or not. If this can not be down, option #2 would be to have a macro button that when clicked, it would do the same thing above. In this way, we would not have to manually reset all the in's to outs every morning for some 80 employees.