rrhg101
New member
- Joined
- Apr 23, 2019
- Messages
- 2
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2019
Hi all,
I followed room planning tutorial on youtube by Trevor Easton. But il's not complete at all.
I see in the booking sheet, "morn" and "aft", but if i want to book a new client in the same day, i've an error. I understand that it was a filter for duplicate date. How to make it run if end day in the "morn" and next booking "aft" for a new or add a choice, for more flexible, "morn" or "aft" on start day and end day ?
I'm in Excel 2019 but in French langage may be you'll have an error, must change langage to french in windows current region (sorry)
Thks for your help( Sorry for my bad english )
This is the file for more comprehension.
View attachment Template-Room-Booking (1).xlsm
I followed room planning tutorial on youtube by Trevor Easton. But il's not complete at all.
I see in the booking sheet, "morn" and "aft", but if i want to book a new client in the same day, i've an error. I understand that it was a filter for duplicate date. How to make it run if end day in the "morn" and next booking "aft" for a new or add a choice, for more flexible, "morn" or "aft" on start day and end day ?
I'm in Excel 2019 but in French langage may be you'll have an error, must change langage to french in windows current region (sorry)
Thks for your help( Sorry for my bad english )
This is the file for more comprehension.
View attachment Template-Room-Booking (1).xlsm