HI
I created single selection dependent dropdowns by using formulas. By using this as reference, Can you please create multi selection dropdowns ((filter type dropdown). Add "All" option in all dropdowns. Based on single/multiple selection , Data should filter in the same sheet (Sheet - "Sample Data")
I would appreciate If anyone help me.
Regards
raj kumar
Last edited by b_raj_kumar; 11-12-2021 at 10:12 PM. Reason: I have clearly stated what the requirement is
Administrative Note:
We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.
Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.
(Note: this requirement is not optional. No help to be offered until the link is provided.)
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.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
hi
iam very sorry. i thought that all forums are individual forums. my question posted (through my friend) in chandoo.org. (https://chandoo.org/forum/threads/cr...4/#post-280180). Next time I strictly follows forum rule #3 (& all rules) & won't do any cross post.
regards
raj kumar
Last edited by b_raj_kumar; 11-13-2021 at 01:34 PM.
The forum rules here (and at many other locations) do not forbid crossposting. If you do, then we ask that you indicate where you are crossposting. In that manner, no one is wasting time trying to solve an issue that has been resolved at another location. Read the link in Ali's post for a better understanding.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
This is an example of 3 dependent data validation, with VBA. You can easily set up more than 3 dependent data validations as needed.
Notes:
1. You only need 1 table as data validation source, 1 helper column, 1 named range & 1 simple formula in data validation (ie =xName).
2. The columns where data validation reside may or may not be contiguous.
3. The list in the table may have duplicate, empty & unsorted, but the code will make the list in data validation unique, sorted & non-empty. The list is also dynamic, you can add more data as needed.
4. In the range with data validation, changing or deleting cell contents will delete cells in the next column with data validation. It is to maintain data consistency.
5. But one caveat of using macro is when macro changes/writes something on sheet it will delete Undo Stack, so at that time you can't use UNDO. In this case it happens every time you put the cursor in a cell with data validation.
Example:
Thank you for reply.
My requirement is, i need multi selection (filter type) dependent dropdowns.
I created single selection dependent dropdowns (A2:G2 -- by using formulas). in place of same dropdown cells, i want to create multiple selection(filter type) dropdown. Based on the multiple selection , i have to create summaries, charts.
Note: in the multi selection drop down Please add "All" option. Based on multi selection (VBA Event) , filtered source data should be placed in other sheet.
I will be grateful if you can help me...
Last edited by b_raj_kumar; 11-18-2021 at 06:27 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks