drop down

Hi everyone. I have a bunch of information in a single table. I want to use 2 drop-downs and then a Vlookup with indirect function to call that data out on another part of the sheet. Everything that I've seen so far shows making dependent lookups based on making multiple tables. I can't do...

I'm beginning to learn to code in Excel, and I have a question about grouping items. I have about 100 different "types" of items that are separated into about 5 groups based on how I describe the item. I created a user form that allows you to choose the item from a tiered drop down list and...

I have a Drop Down. Assume I select "Varia Single 25/2,3 90" Now I want to return other values where either 25/2,3 or 90 are included. I want the whole value to be returned. List <colgroup><col></colgroup><tbody> Pexflextra 25/2,3 90 <tbody> Uno 25/2,3 76 <tbody> MX-Radiflex 40/3,7...

I am stuck, have a table with [ID, Fname, Lname, Amount]. Need to create drop-down list showing [ID, Fname & Lname]; ID be returned to be used in other calculations. Is this possible in Excel or VBA?

Hi Guys, How do you create searchable drop down list as seen on google sheets? I have excel 2016. I want to use the drop down to complete a column in a table. I know I have to use data validation. Thank you.

I have an excel file that when I select "consultant" under "To be processed by" I want the rows values from Date to Status to be copied to another sheet. Sheet 1 called "Requests" and Sheet 2 is called "Consultant". I only need this to be for the consultant selection. I may be excel challenged...

Hello, My question is about Drop-Down table lists and how to get the index of that specific selected item from the Drop-Down list so I can access the other columns info from that row index. I have a macro-based excel workbook that has two worksheets ("Pointage" and "Employeur"). The "Pointage"...

Good Morning, I have an excel spreadsheet where I input certain data per week and for each additional week I have to create a new sheet. I was wondering how could I make it where I could have a drop down of the date and then enter my numbers for the week and it save the numbers I enter and I...

I need to be able to select a value from a two different drop down lists in internet explorer. The first one data will displayed as tree. The second one data displayed as drop list. You can get excel file from this link...

I want to populate a combo box from a SQL table. I have an immediate problem in that when I create the combo box I cannot refer to it. It takes a default name of dropdown1, but when I attempt to reference this in VBA using: With Sheets("Sheet2").dropdown1 I get an error: Run time error 438...

Hi I am attempting to create a drop-down list which populates based on the value in another cell. For example, if cell A1 has the value "Supplier A" in it, then the drop-down list in cell B1 will contain all the products supplied by Supplier A. The issue I am having is the table on a separate...

Hi, I just wondering to know how can I make a drop-down list to visible a certain table based on my selection and the rest of the tables be invisible? Thanks

Hi All, I'm hoping someone can offer advice. I would like to know if there are any alternatives to drop down menus for a shared workbook. Something where only a predetermined list of options can be entered into each column. The reason is that I wanted to make a database of clients and...

Hi, I basically want to create a drop down where you can select an age group and it simply lists the top 20 medical conditions in one column, number of admissions last year and this year, in the next two columns. Basically I have five tables by age group - 20s, 30s, 40s, 50s, 60s For each...

Hi I was wondering if anyone can provide some guidance with a problem I'm having. I'm currently attempting to create a sheet to track staff leave from a table which is to be used as a default, but editable by user with a drop down. So far I'm managed to use a nested vlookup and Hlookup to...

Good Morning, I'm sorry if similar question had been asked for several times before, I would like to make dropdown list to navigate between hidden sheet using combo box ActiveX. The script for dropdown sheet list it self I already have it from here like this: Private Sub ComboBox1_Change()...

Good afternoon Folks, I have run into a small issue using Excel. I have created a drop down list, and i'm trying to figure out how to subtract how many times a name were to come up. for example If i have 35 tickets to the movie jumanji, If i select from the drop down list Jumanji could i now...

So I have a spreadsheet that has a drop down of 300 schools. Depending on what you select in that drop down, the table below magically updates using vlookups. There is a graph that is linked to that data. https://ibb.co/jaeCKb so the yellow is the drop down E2 The ask of me is to print (PDF)...

I am hoping someone may be able to give me some guidance on setting up a validation list or combo box to update on the fly with items not in its source. The information in this link works beautifully if the list is stored within the same workbook -...

hello all, i am looking for help with a somewhat pain in the butt task. i have one list of items, lets say 1-30 i am wanting to create 4 drop down list that will pull from this list and if i select 1 in group 1 then i do not see it in any of other drop down list, and so on, if i select 15 in...