Search results

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...

i am bit frustrated now. I added the RoomID parament (pls see code below). And it's ok when i try to enter some records with today or before today, it pops up the double booking message. However, when i try to enter a new entry with future date with the same time slot, it can get it pass. For...

Situation comes a bit complicated now. I have 5 types of room which has its own max capacity. One is 10, another one is 4, others are 1. i tried to add the max capacity check coding to the end, but seems the logic not right. E.g. For room A which max cap is 4. I filled 3 records with the same...

Hi Sir, as you said, after adding the parameter, it works flawlessly. And also I tried to add the SQL code from the above, seems much easier to understand, but let me learn the VBA basic first. Thanks all.

Thanks :) , let me take a look, i haven't learnt SQL yet, but will definitely be the next step for it.

You are right. Let me try. Thanks for your help.