Hello,
I'm having an Excel workbook with two sheets, one base sheet and one 'database' sheet. The database sheet consists of main-processes with several sub-processes, it looks something like this:
Capture.PNG
Now, in the main sheet, there are dropdown lists of the main-processes. I want the user to select some main-process, and all the sub-processes to appear automatically per main-process.
I also want a template version of the sheet, where other main-processes, with various amounts of sub-processes, can be added in the database. The selecting from the menu should then still work without changing the formula or VBA code.
I'm looking forward to your answers!
Edit: I've added an example file with more explanation.
Bookmarks