LinkBack URL
About LinkBacks
Dear Friends,
Please help me in this project. in room status sheet, room status is provided but i want in sheet named data that allotted room should not come in drop down list.
Room Allotment:remove allotted room from dropdown list
Dear Friends,
Please help me in this project. in room status sheet, room status is provided but i want in sheet named data that allotted room should not come in drop down list.
Hi,
What's the ultimate aim here. If it's to know which rooms are vacant at any one time then use a Pivot table - see attached.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Hi amdrosm
Just need to delete Alotted from the Named range "Stats" in column I
Good Luck...
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
Also....Add a comment if you like!!!!
And remember...Mark Thread as Solved...
Excel Forum Rocks!!!
Thank you so much for your response.
Dear i want that in sheet 1 when i select drop down list of room only available room should be there in drop-down,so that it can be allotted to the guest. please any help.. much appreciated.
The attached contains a simple filter macro. Click the button.
thank you so much..let me elaborate my problem.actually i am making excel for hostel room booking. i want to allot room such that room number should not be repeated i mean single room for single person & only unoccupied room should be there in drop-down list to select empty rooms.if i am assigning one room than it means it is allotted,once it is allotted disappear from drop-down.
At the moment you have Room Status which appears to be a list of ALL rooms marked as to their status.
How do you operate this system? What do you want in the Data Sheet? I'd assumed you wanted a list of all the vacant rooms.
Can I suggest you tell us what you start with, what you DO and what you expect to SEE as a result.
Dear Richard,
well as a excel student trying to make hotel/hostel room booking system.
step1:assume i have few empty and allotted rooms ,that data i am updating manually in second sheet.
step2:first sheet"Data" is my main sheet in which i will choose room from dropdown list.
step3:i want that if i allot first room from drop down than remaining vacant room should be present in list,allotted room will not be shown.
I understand steps 1 & 2
To what does Step 3 refer. Is that the Data Sheet where you select a room. At the moment that drop down contains all rooms whether Vacant or allotted. Are you saying that the Data drop down should only show Vacant Rooms?
If so what then? And what's the point of the column B VLOOKUP since by definition anything selected in column A WILL be Vacant.
Is this a homework exercise? If so we generally prefer to offer help & guidance rather than do the job.
You've made a start which is good, but what's the answer to the above, and then is there a step 4 and if so what do you want to do next? Personally I'd have thought you'd only need one drop down cell which contained a list of Vacant Rooms from which to pick. Then having picked one what next...
You need to clarify how this system is used and tell us what appears after each step.
Ok. Let me clarify how I understand your requirement and you say whether I have it rightOriginally Posted by amdrosm
1 You manually update the sheet "room status"
2 You want , but do not currently have, a drop down list in sheet "Data"
3 You want this drop down box to list only vacant rooms based on sheet "room status"
is that right?
If so all you need is a filter on Col B in "data" to filter out Allotted rooms
I think what amdrosm wants is as follows:
He wants a drop down list with room no's and if the rooms have been alotted then only the available rooms must be shown in the dropdown....Not all of them...
It is doable but not a straight forward solution
yes dear sintek,
this is what i want.
Have a look at this link:
http://www.contextures.com/xlDataVal03.html
http://www.get-digital-help.com/2011...ection-filter/
You also need to define what happens next. This shows the available rooms, but doesn't yet feedback to remove that room from the list... What is the function of data column B???
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Thank you so much glenn.. There is no need of column b.it is just for reference. i will try and update.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks