Excel vba-Populating cascading drop down based on values in another sheet with ids -


how build cascading drop down in excel macro vba code below scenario.

main sheet has business process,sub business process , activity name in macro code written.all fields should drop down.

business process name , sub business data retrived data in businessprocess sheet. activity name retrieved activitysheet dependent on business process name or sub business process name applicable.

hierarchy bbusiness process--> sub business process name -->activity name

if no sub business process name bbusiness process--> empty -->activity name

business process sheet

businessprocessid | businessprocessname |subbprocessi | subbusinessprocessname 1                 |b1                   |null         | null 2                 |b2                   |3            | sub b1 2                 |b2                   |4            |sub b2 5                 |b4                   |null         |null

activity sheet

businessprocessid | businessprocessname | activityid |  activityname 1                 |b1                   |1           |  a1 1                 |b1                   |2           |a2 2                 |b2                   |3           |a3 3                 |sub b1               |4           |a4 4                 |sub b2               |5           |a5 5                 |b4                   |6           |a6

based on above 2 sheets main sheet should have below 3 fields drop down.

businessprocessname | subbusinessprocessname |activityname b1                  | null                   |a1 b2                  | sub b1                 |a4 b4                  |null                    |a6

kindly in writing macro above considering 3 individual worksheets in excel.

to answer question how build dependent drop down. suggest start looking @ following links:

http://www.contextures.com/xldataval02.html

http://www.siddharthrout.com/2011/07/29/excel-data-validationcreate-dynamic-dependent-lists-vba/

the idea build sheet co-relational data (and maybe hide sheet) , use formulas in data validation list box refer co-relational data.

hope helps start off.


Comments

Post a Comment

Popular posts from this blog

resizing Telegram inline keyboard -

telegram's inline keyboard great feature lots of different use cases. inline buttons added list of items this: inline_keyboard = [[inlinekeyboardbutton(text="button", callback_data="button"), inlinekeyboardbutton(text="reset",callback_data="reset")]] inline_keyboard_markup = inlinekeyboardmarkup(inline_keyboard) update.message.reply_text("hi", reply_markup=inline_keyboard_markup) the above code adds 2 buttons each half width of chat screen. i know the normal keyboard button there resize_keyboard parameter somehow can used. my question is there way resize inline buttons ? example make full width or quarter width. unfortunately, can't now. :( you can suggest @botsupport , might add feature next version.
Read more

javascript - How to bind ViewModel Store to View? -

i'm pretty new ext js , trying embed multiselect inside panel . the viewmodel has stores property can see here: ext.define('test.view.controls.search.searchfiltermodel', { extend: 'ext.app.viewmodel', alias: 'viewmodel.filter', data: { title: '' }, stores: { test: { fields: [ 'id', 'name' ], proxy: { type: 'ajax', url: 'api/test', reader: 'array' }, autoload: true } } }); i bind in view this: viewmodel: { type: 'filter' }, layout: 'fit', border: 1, plain: true, scrollable: 'y', layout: 'fit', bind: { title: '{title}', }, items: { xtype: 'multiselect', scrollable: false, allowblank: true, ddreorder: true, bind: { store: '{test}' }, valuefield: 'id', displayfield: 'name' } ...
Read more

c - Why does alarm() cause fgets() to stop waiting? -

i playing around signals in c. main function asks input using fgets(name, 30, stdin) , , sits there , waits. set alarm alarm(3) , , reassigned sigalrm call function myalarm calls system("say pay attention") . after alarm goes off, fgets() stops waiting input , main fn continues on. happens if change myalarm set variable , nothing it. void myalarm(int sig) { //system("say pay attention"); int x = 0; } int catch_signal(int sig, void (*handler)(int)) { // when signal comes in, "catch" , "handle it" in way want struct sigaction action; // create new sigaction action.sa_handler = handler; // set it's sa_handler attribute function specified in header sigemptyset(&action.sa_mask); // "turn signals in sa_mask off?" "set sa_mask contian no signals, i.e. nothing masked?" action.sa_flags = 0; // not sure, looks aren't using of available flags, whatever may return sigaction(sig, ...
Read more