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.
I’d do it in steps. The last step is using ‘conditional formatting’ based on text in a cell.
For the first step, arranging the data, I’d use the Filter formula. And use multiple variables, referring to cells you can adjust as needed. Once you get everything working, use Sort combined, just for order. It might take some practising, so I’d start with a small test sheet.
Simple example: =Sort(Sheet1!A:G;Sheet1!A:A=A1*Sheet1!B:B=A2*Sheet!C:C=A3).
For the first step, arranging the data, I’d use the Filter formula. And use multiple variables, referring to cells you can adjust as needed. Once you get everything working, use Sort combined, just for order. It might take some practising, so I’d start with a small test sheet.
Simple example: =Sort(Sheet1!A:G;Sheet1!A:A=A1*Sheet1!B:B=A2*Sheet!C:C=A3).
I understand. Yes, that's the way I've also thought about it. Looks like Riny gave me an amazing solution. I will continue to develop it forward. Thank you for your message. Much appreciated it.