Forum Discussion
Solved
interesting Booking template with multiple variants in Excel
Hello guys, this topic is for those of you who want to push their creativity a bit further with excel. I've tried to make this example as easier as possible with all the respect for your time and ef...
Alecs Not convinced that your template is the most effective way to approach this, but if it works for you, it's good enough. Played around a bit and added conditional formatting to display the status of the booking, and a FILTER function to pick-up the INFO on the first day of the booking. And it also deals with multiple bookings on one day.
See attached.
Riny_van_Eekelen
many thanks! I've tested it out just now and worked as it should. I've changed the Concatenated function as you suggested.
Can you please take a look on the new topic that I've opened? There is an problem that I'm facing and still did not managed to solve it.
here is the link: https://techcommunity.microsoft.com/t5/excel/change-cell-reference-formula-row-based-on-input/m-p/3438343#M148344
Have a nice day! 🙂
many thanks! I've tested it out just now and worked as it should. I've changed the Concatenated function as you suggested.
Can you please take a look on the new topic that I've opened? There is an problem that I'm facing and still did not managed to solve it.
here is the link: https://techcommunity.microsoft.com/t5/excel/change-cell-reference-formula-row-based-on-input/m-p/3438343#M148344
Have a nice day! 🙂
Alecs Glad I could help. Noticed that you already received help on your new topic.