I am trying to create a check in and check out sheet for visitors. I've attached what I have so far. Basically the Check in will auto fill Name, Company, Visiting, and Time in. This will also fill Column J if there is a name without a time out. I used an if then to fill that column. In the Check Out macro I've created a ComboBox that uses column J for the Names List. The problem I'm having is in the data validation portion for having to check out. I created a check out button that will populate names based on a list in the J column. But when I hit the OK button I'd like the macro to search for that name and fill in the tMacro Test.xlsmime out cell with a date stamp. I'd like it to allow duplicates as well. For instance if Jane Doe came in at 10 am and signed out at 11 am, then came back at 2pm I'd like it to not change the time stamp for earlier but change the most recent entry. I hope this makes sense to someone. I am really struggling. I was able to create the VB to enter in new data. Let me know if I'm missing information.
Bookmarks