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.
- 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.)