Hello Forum,
I have 2 dropdown lists for QTY. The total quantity for both selected QTY can be equal or less than 8. Is there a way Excel can make the second dropdown list automatically adjust the QTY, so the user can choose the QTY to meet the condition of equal or less than 8? Please see attached file.
Thank you for your help.
Thup_98
In the second dropdown use this source for the dropdown-
Check attached.
Please Login or Register to view this content.
Happy to Help
How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html
"I don't get things easily, so please be precise and elaborate"
If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.
Sourabh
It works perfectly. How can you come up with #10 in the formula? Could you explain the formula?
Thank you so much Sourabh.
Thup_98
The formula specifies the favorable range in Column M.Please Login or Register to view this content.
So if you have 3 in C4 the formula would give-
Please Login or Register to view this content.
I got it. Thank you Sourabh
Thup_98
Glad to know that helped
Thanks for the feedback and reputation!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks