Recent content by alcwho

Thanks a lot :) let me try.

Hi, I got a row number, say row 315, then i try to start vlookup from that row to the end. So my formula will look like: =vlookup(A1,$B$315:$D$500,2,0) however, row 315 is a dynamic cell depends on the result i generate in another cell, e.g. cell B1. Cell B1 contains the exact row number (e.g...

Thanks all :)

Thanks for your help. Let me take a look :)

Hi, I have the following table for value lookup. Actually, a user has 2 criteria, i) what Big group he is in; ii) what sub group he is in under the Big group. Then based on these 2 criteria, lookup what fruit he needs. For example, User is in i) B-2 Big group; and ii) be-2 subgroup, then he...

Again, thanks a lot. I got a very quick question. Got one situation. RoomID 3 got max cap for 4 ppl, and the first reservation starts from 10am to 12pm. Then make 3 more records to test, it looks fine. However, if I make a record for 11am to 12pm (OrderID 33) or 11am to 1pm (OrderID 35), it...

Millions thanks for your help on this. I'll try to learn SQL as you suggested. Again, much much appreciated for your help.

Very much appreciated for your help. Let me take a look.

Hi Arnelgp, Here is the sample file I created. You can find the OrderF there. After open the OrderF, user type the Start date, End date, and Room, then it will run the VBA to check. you will also see my RoomTypeT (table) that contains field called "Maxcapacity" to show the max cap for each...

Millions thanks 🙏🙏🙏, let me try.

Sorry about that. Someone will book a specific room for a specific time slot, so in this case i think its for specific room. Very much appreciated for your help🙏🙏🙏🙏🙏🙏

Yes correct, after a user choose the start date, end date and room, then VBA code will check. Thanks again.🙏🙏🙏

Anyone can help?🙏🙏🙏

Sorry, actually its only 5 rooms from Room A to E. I amended the post. Thanks🙏

Sorry, it's not very clear in the very beginning. Here is the situation. I have 5 rooms for booking, each room has seats capacity as follow, Room max capacity: - Room A: 10 seats (means has 10 different booking with same time slot) - Room B: 4 - Room C to E: only 1 In addition, if I mark a...