dynamic drop down list

Need help creating a dynamic drop down list in Excel. My current option is very manual and requires me to go to another tab and filter data by XYZ Code and then copy and paste all possible XYZ Descriptions horizontally in the desired sheet. Problem is there is about 1000 records (rows) and in...

Hi, I am trying to create a multiple dependent dynamic data validation in multiple rows. I have tried doing it through name table / Indirect Function and it's working only in the first row. In the Second Row (Column 1) when I am selecting different data, in that case in Column 2 its still...

Hi, I'm looking to create a macro that will allow me to setup a spreadsheet template whereby the user is prompted to select one value, then another and on the basis of these 2 other values are populated. So for example, the user is prompted to choose a category and then a division, which then...

I am new to using the Developer tab and Combobox's in Excel. I am working on a spreadsheet for work and want to use some code I found online. I want the combobox to pull data from multiple (dynamic, if possible) data validation lists (demographic info) on a separate sheet. The sheet I want to...

Hie, So basically i am creating a form which is more or less like a invoice. There are 4 types of choices from which the user will select, by each selection would give me an another list to choose and so on untill it reaches the last one which is the price, for instance Type- Stock Range...

I'm trying to create a dependent data validation list but have encountered some issues. I have 36 ranges and thought I would be able to use index & match to find the name of the active range based on the reference cell values. If my input value was 80, the dependent drop down list should...

Hi, I want to create VBA Macro code to create a drop down list in sheet. and values of that list are copied from another sheet. It should be dynamic code. Values to be copy are not constant. they are increasing often.

Hello, I've got a problem with some cascading list boxes and a single drop down. There are 4 list boxes and 1 drop down and a user selects options from each of them to make a configuration. They are embedded in the worksheet "Instructions" (not a Userform). I encounter an object required error...

Hi, I need your help in creating Dynamic Dependent Dropdown lists (multiple) I have checked below link, but the Drop Downs Position is fixed Create dependent drop down lists containing unique distinct values in excel I have a requirement here like, user can enter a number say 4. and there I...