dependent drop down list

Hi, I have a spreadsheet containing a list of products and Promotions. Each product can have multiple promotions, and one promotion can be found in different products (many-to-many). This spreadsheet is updated constantly. I created a UserForm with a dropdown list containing unique products...

Hi all, Trying to create a dependent drop down list, but ran into some issue. I want to create a drop down list that is dependent on a previous drop down list. The first drop down list includes the management unit, which is already working fine. For that I created a small macro that retrieves...

I am trying to do dependent drop down in excel vba Range("Q2").Select With Selection.Validation .Delete .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _ xlBetween, Formula1:="=INDIRECT(M2)" .IgnoreBlank = True...

Hi all, For the first time I tried creating my own VBA code to assist my worksheet. I had the issue that the cells of dependent drop down lists retained their value while their parent was changed. I have looked up multiple types of code that seem to solve this question, by using VBA. All...

I have a dependent drop down set and it is working fine in the first cell of worksheet 2. Now I want it to work for the other cells down the column. I am using the following: =INDIRECT($E$2) Cell E2 is a drop down list from sheet 1 I want the dependent drop down for the entire column (F)...

I'm trying to make a table that determines the price of a track depending on the length of the track and the track type. What I want is to have a table that does the following: Column A= Track Type (Ceiling fix and Face fix) Column B = Track Length Column C = Track Price If track type...

Hi All, I have a drop-down data validation question. I have 5 columns that users are required to fill out when adding a new row. I'd like the help the users by adding drop-boxes that will narrow the choices down for them and reduce inaccurate mapping. I've figured out how to have dependent...

hello all, my question is a little tricky ... let's go: What I really want is to create a data validation (list) using a Dependent Drop Down Lists; which means that depending on which text is on cell A1, the drop down list would show a different set of options. For that on the data validation...

I have 3 Different worksheets within the same workbook. Worksheet 1 contains this Table 1 Table Header is "System"(Not full table): All Systems are entered by hand. <colgroup><col style="width: 191px"></colgroup><tbody> System 16 C URSAE MAJORIS 169 G. Canis Majoris 18 PUPPIS 19...