Excel VBA (part1): Dependent Dropdown List by Index and Match
In the video I demonstrated a excel template by using the listbox of excel VBA userform for dependent dropdown list to select item when you use excel as a tool to collect inputs from your organization for analysis and reporting.
To create the features in template I divided the creation steps by 4 videos. In this video part 1 which is focusing on how to create dependent drop down list by Index, match, Unique and indirect functions , In coming Part 2 video I shall focus on how to create listbox by VBA userform for selecting item from dropdown list. Part 3 video I shall shortly brief on how to deep-hidden Dimension and Admin tabs. And also give a hint on how to protect front page with the editable fields. Last video part 4 I shall share a VBA procedure to save file by naming conventions.
References :
Power BI OLS URL : https://powerbi.microsoft.com/en-us/b...
SQLBI website for Tabular Editor Free Download URL: https://www.sqlbi.com/tools/tabular-e...
For more info of my BI & Analytics, please refer to the following website links:
My BI & Analytics Website:
https://sites.google.com/view/mikegua...
My blog website :
https://mikeyubianalytics.blogspot.com/
