I have a list of lessons booked each day, with a cut of of scheduling or cancelling those lessons by 3 PM the day before the lesson. For example, customers could book a lesson on Friday for Sunday or Monday, but could cancel either the day before prior to the cut off.
I want to prepare a sheet of the lessons booked for Sunday and Monday in a check Friday evening. I would provide this list to staff Friday evening. They would add a similar sheet to the book showing the same list, but including any changed to the list. They would generate this sheet after the 3 PM cut off.
I need the workbook to compare the list from Friday, to the list on Saturday and Sunday to either show a condition if the lesson is new or to show only the new lessons. This way staff would only have to check the new items. The list generally runs 70-120 lessons, but new would likely only be 2-10 lessons.
Cancelled meetings are no issue, as they do not show on the list. Only confirmed, life links/lessons. Ideally, if this can simply show in the original new sheet with a lookup or if statement and conditional formatting, great. But I am not adverse to using a VBA routine to create a new sheet listing only the new items, or a userform.
I have listed only the Friday and Saturday check of the Sunday schedule, but I would need to be able to do the same for Monday, figuring I can apply the same logic to the next day (Friday check vs. Sunday check).
Thanks in advance for your efforts and ideas!
Bookmarks