Good evening everyone,
I am trying to apply a 3-tiered dynamic drop-down list in cell ranges named: BTClass, BTDes, and BTDes from the table named "tbl_BudgetList". Source data is from the cell ranges named: Classification, Category, and Description from the table named "til_RecordsList". I really don't know where to start, I've done some basic VBA coding before, but nothing like this. Does anyone have any ideas?
MOD EDIT: Non-VBA solution now required.
Last edited by AliGW; 12-14-2020 at 12:39 PM.
Here's an example of 3 dependent data validation.
You can adjust the code in sheet1 code in this part:
=============== YOU MIGHT NEED TO ADJUST THE CODE IN THIS PART: ===================================
Let me know if you need more help.
Give this alternative a try - the comboboxes are ActiveX and locate over the selected cell
Logical progress left to right, the table will grow if you enter in row order - do not enlarge the table by dragging.
torachan.
I have closed your duplicate thread and moved this to the functions and formulas section. Please continue here.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Thread closed, as the OP has decided to post in the Commercial Services section instead.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Kogen 
Register To Reply
Bookmarks