drop down

Good Day my brave excell'ers! I have a sheet (Sheet2) with the list below [Sheet2] <tbody> a b c 1 Bob obs tech 2 mark nav elec 3 john tac mech </tbody> On [Sheet1] I'd like to have a Drop-Down list in A1, then when a name is selected it populates (B and C) with the relevant...

Hi MrExcel, I'm fairly new to VBA and macros in Excel and could use more than some help with it! Currently i'm working on creating a report where i have a drop down list of countries (in cell C2) with the list of countries (in column A) and their datas across row A7 to S65. I would love to know...

Hello everyone, I have a file with projects' staffings. Some of the workers assigned to these projects are temporary employees, some of them are permanent ones and some of them are leads. I would like to create a conditional formatting rule that highlights the permanent, associate leads and...

Greetings, is it possible to have (3) dropdown lists equal a dollar amount? Task at Hand: I will try to simplify to help make sense. Let's use a restaurant menu as an example. Depending on your order and the options chosen, the total will be different. Dropdown list 1: Types of meat-Chicken or...

Hii, I am trying to create a sheet that would track samples distribution to customers. In the attached sheet under the Tracking Sheet tab I've set the "HCP" column to be a drop down menu to avoid miss spelling names. I want to avoid miss spelling names so the pivot table would be accurate...

Hello, I am trying to copy a column from Worksheet 2 to Worksheet 1 based on my drop down box on worksheet 1 which is made up of the column headers on worksheet 2. My drop down box is on worksheet "Drawing Content" in cell B1 and the column headers are on worksheet "Master" and start in E1 and...

I had reached out previously about getting a code so that based on a selection in row A if it were to be switched to completed that the entire row would be cut and then put into the Completed tab. I wanted to see if I could get this code edited so that the same option for when it is completed...

Hi all, I have a long list (several hundred rows) and I am trying to create drop-down lists that each contain about 5-6 options of my list. I'm sure this can be done with VBA but is this possible to do with basic Excel functions? For instance, drop-down list contains cells A2:A5, drop-down...

Hey guys, I'm running into the issue where I would like to create a drop down in each cell in the range h4:h74, and for each drop down, have each drop down reference a new data set from B86:BT86. So for cell H4, the drop down in that cell should reference B86:some ending point, H5 should...

I have a named range without blanks in it. I have configured cells in a column to be validated against this list. If I type in a value that is not in the list and tab out of it, I get the expected error message, but if I leave the cell blank I get no error at all when leaving the cell. I have...

I've tired a lot of different approaches and still have not figured out any way to overcome the issue. When use the .selectedindex = 10, the option appears just like i wont it to, but the date range boxes will not appear after i've picked the option. ive tired .focus .fireevents .click and many...

I've been reading up on a solution to this mouse rollover problem. I've found bits of the solution on various sites, but nothing that ties my needs together. Basically, I have a drop-down list of various exercises on Sheet1. Upon hovering over the selected exercise (ie. squat), I need a VLookup...

Hi there, I have two sheets on a workbook - a summary table and a master record table. For each record on my master table, I want to add it to a count on my summary sheet (see below). <tbody> Summary Table Jan Feb Mar Apr May Name 1 0 0 0 0 0 Name 2 0 0 0 0 0 Name 3 1 1 0 0 0 Name 4...

Hello! How can I set a data validation list such that if the drop down value in the cell is deleted, the cell will automatically show a default value (i.e. "-Select-")? For example, I have a worksheet with multiple drop down lists that I want to show a default value of "-Select-" once the...

Hi All you Guru's, I need a little help. I have 5 Dependent drop down Lists. Created from the Data Validation. I would like to reset the selections once the user decides to do another selection. I created this code below. The idea is the if the user makes the 5 selections and if he chooses to...

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.