Forum Discussion
Automatically updating "Calendar" when new data is added?
Hello aj1152,
VBA should do it, I've provided the file on the attachment, the code will reflect the person's checked in and out on the database into the Calendar View sheet, and handles overlaps by creating unique room identifiers and highlight assignments in light green and yellow if the same building and room number has two or more person accomodating it.
Provided an "Autopopulate" button to run the macro.
Hello aj1152,
VBA should do it, I've provided the file on the attachment, the code will reflect the person's checked in and out on the database into the Calendar View sheet, and handles overlaps by creating unique room identifiers and highlight assignments in light green and yellow if the same building and room number has two or more person accomodating it.
Provided an "Autopopulate" button to run the macro.
- This is great! Very much appreciated. I'm going to try to update the VBA file, tweaking it to make it work with my actual real-world data (e.g. I need to also include the occupants' last names) but this is very very helpful! If I get stuck, mind if I ask for some support?
- Yea sure, there's a lot to improve in the code itself anyway.
I forgot to mention, on 'Calendar View' sheet, on header Dates, it should be manually typed and must be in date format (since when I open your sample file it wasn't on date format.)
