cascading

Hello all, I am trying to put together a sign-off sheet of responsibilities within my organization. To do so, I've created two cascading drop-down lists via Data Validation: Independent Drop-Down: Department within the organization Dependent Drop-Down: Position in the corresponding department...

I'm trying to build out a deployment forecast that has two main components: a probability of the deal's timing in a given period, and a % of the deal deployed in a given period. For example, suppose we're forecasting a deal with 100 devices. If there's a 100% probability it closes in...

Here is a gross over-simplification of my dataset in Excel (it's larger and more purposeful than this). It's in a table, at this point with quite a few more columns and vastly more rows. <code style="margin: 0px; padding: 0px; font-style: inherit; font-weight: inherit; line-height...

I'm trying to setup multiple cascading comboboxes in a userform. I've been able to get combobox2 to show the relevant managers for the selected entity in combobox1 (example: if I select Entity 4 (in combobox 1), it should display Apple and Cash & Equivalent in Combobox2). However, I would like...

Hi Experts I'm a newbie to VB and I am trying to figure out how to cut and paste data from the first work sheet into other work sheets. Here is the catch however: Sheet 1 has 10 tables that is cascading. therefore i need to figure out a way to cut and paste each table into a new work sheet...

I have created cascading drop downs using the approach outlined here http://www.contextures.com/xlDataVal02.html I have the following 1. Concept Area (List 1) 2. Subject area within each concept area (List 2) 3. Entity within each subject area (List 3) The only issue I have is if I say...

I need to put together a worksheet that assists users in selecting a valid account for posting activity. Prior to viewing a list of acceptable account numbers (with full descriptions), the user must 1st select from 4 other drop downs. Column A has 2 possible selections Column B has 2 possible...

I wonder if anyone can help me. I've created a userform with cascading comboboxes and other fields and when completed the userform populates cells B3:H3. The problem that I'm running into is that I need the form to populate the next row with the next entry of information. For example, the...

I wonder if anyone can help me. I'm trying to load the comboboxes with data from a different worksheet. However, no matter what code I try it only loads from the active sheet. Here's an example of one of the subs that I tried. Any help would be greatly appreciated! Private Sub...

I apologize if this is too elementary for some on the forum. I'm just trying to create a user form with two cascading comboBoxes (i.e. the list in box2 is dependent on the selection in box1). I've looked all over and have tried various code suggested on different forums, but I just can't get...

Hello all. I'm trying to create a series of 3 cascading combo boxes using a technique I found on this board. The first combo (cbo.Areas) contains a list of "Body Areas" derived from the table of the same name (with columns: AreaID and AreaName). The second combo (cbo.Parts) lists more...

Hi at all! I got a big table in the following style: vegetable green zucchini vegetable green broccoli vegetable red tomato fruit red strwaberry fruit red raspberry fruit yellow banana I already managed to have 3 listboxes popping up subsequently but...