dropdown list

Hi, I'm creating a sheet that shows story points per sprint in order to chart it. The table has projects in the first row and sprints for the columns and the data is filtered based on these and dropdown cells. Is there a way to put a wildcard into the dropdown cell that will allow the data to...

Hi all wondering if someone could help me out. What im trying to do seem simple but i was unable to figure it out with either a formula or a macro any help would be greatly appreciated here's my problem I would like to have value from Sheet(1) column C and value from Sheet(2) Column E...

Hi, Calling all Excel geniuses, I’m working on a project for a friend, I’m already way beyond my comfort zone in Excel, and am have an issue that I can’t get around. My project involves making a sheet that acts like a form with each row being a series of dropdown menu’s (to limit the users...

Hi, Calling all Excel geniuses, I’m working on a project for a friend, I’m already way beyond my comfort zone in Excel, and am have an issue that I can’t get around. My project involves making a sheet that acts like a form with each row being a series of dropdown menu’s (to limit the users...

Hi, I'm trying to write a VBA script for Web Scrapping. I have to select an item form a ListBox (********** tag in HTML) by its name. Does anybody know how to do this? I'm using this libraries: 1. Microsoft Internet Controls 2. HTML Object Library Here you have some of the HTML code...

I would like to create a dropdown list with elements that are based on the value of another cell (note that I do know how to create dropdown lists). For example: A1 is the master cell, A2 holds the dropdown list and selected value A1 = 1, A2 list: Apples, Oranges, Lemons, Pears A1 = 2, A2...

I re-created an excel worksheet I want to use to track a breakdown of hours for equipment activity per month. I have created named range (cell C1:N1) to populate a drop down list to select a specific month. I am trying to get the chart to change to show data for a specific month when it's...

Hi all, I've been trying to solve this obscure excel problem over the past few days and can't find any documentation about it online. I've an excel document created in Python using xlsxWriter, but for some reason the cascading dropdown list (in column C) won't display at all unless I manually...

I am working on a project where I need to have data validation dropdowns that drill down from a top category. Example below. <tbody> Fruits Apples Red Fruits Apples Green Fruits Berries Raspberry Fruits Berries Blackberries Fruits Berries Strawberries Veggies Beans Green Beans...

Hello everyone Hope someone can help. In a bit of a head banger & up against a deadline. I have a print macro which prints out all of the items selected in a list box loaded into a user form. Works perfectly. Now I need it to only print out the visible range based on filter results. Tried &...

I have a dropdown list with one value “Go” in A2. I want to make possible for users to choose “Go” unless one scenario. In case they choose X1 or X2 from a dropdown list containing X1,X2,X3,X4 in cell B2, they are obligated to fill in a value in C2 before they can choose "Go" in A2. it could be...

Hi, This is my first post, although I've been reading the forum for quite some time. I have what I thought should be a pretty simple problem, but for some reason, I'm stuck on it and can't seem to find anything out there that explains my scenario exactly. :-x What I'm trying to...

Hello all, Hopefully everything is posted in the correct area and I hope I can get my issue across intelligently. I'm creating a "Job Setup" sheet that will refer backwards and forwards to other sheets in this workbook. The scope of the work is doors - interior vs exterior, door types, etc...

Dear friends, Below is the function NoDups populating drop-down list in a user form with unique and sorted values. Can it modified to populate regular drop-down set through Data validation? Function NoDups(rng As Range) Dim arr(), i&, s$, x ' read data arr =...

Hi everyone, I am new to macro and I couldn't find anything how I want it online. Please help. I will have several tabs in a workbook, and each tabs has a dropdown list (data validation ) in cell C3, I want to macro to go to each tab to select the next item in the drop down list For...

Hello, I would like to create 3 levels of dependent & dynamic DropDownlists (Data Validation lists) based on the following ranges: <tbody> LEVEL 1 LEVEL 2 LEVEL 3 1. ACTIVE 1.1. ACTIVE CURRENT 1.1.1. AVAILABLE 2. PASSIVE 1.2. ACTIVE NON CURRENT 1.1.2. ACTIVE EXIGIBLE 2.1. PASSIVE...

Hi, I wonder if there is a way of Displaying a list, depending on the selection of a given cell. For example, if A1 has a drop down list of Cars and Cells B1:B5 displays the name of types of the selected Cars (If A1 = BMW then B1:B5 = X1, X3, X5, A3 & Z4 respectively, and if A1 = Mercedes then...

Hello I am using open office calc (apache) and in my document I have a number of dropdown lists e.g dropdown list 1 has the following entries: Not Selected Yes No In another worksheet of the same document I ask various questions (say to some sales people) e.g (in cell A6): Q1) Would you like...

I have a list of 1000+ drop down lists (all containing the same options). I need to change the selection for all lists. is there a way to do this that doesn't require changing them one at a time? Thanks!

Hi, I have a dropdown list in cell B11 in sheet1 where I can select values from column A in sheet2. Everything works okay, but I would like to have a quality routine that alerts me if the selected value in B11 exists more than once in column A in sheet2. That is, because this value is used...