I want to be able to pick a word from a drop down list and for related information to appear in the next cell. I just don't know the function to do it.
Here's an example: I have a list of first names and second names in adjacent columns.
Excel question 1.jpg
In the 2nd sheet I have a drop down list of the first names:
Excel question 2.jpg
Is there a function to make the corresponding 2nd name appear in B1 when a first name is selected. I've seen examples where INDIRECT is used to create a dependent drop down list in B1 but I'd like the information to automatically appear.
Column C and D are should be picked from a dropdown list (data is in named range on sheet 3).
The choices that have t become available in a dropdown list in column E (values also in named rnage on sheet 3) should be based on the combination of column C and D.
The choices that have t become available in a dropdown list in column H (values also in named rnage on sheet 3) should be based on the value of column C.
I'm not sure the way it is set up now (as far as it is setup) is the way to go.
I need to make a dropdown list (I know how to do that) and based on that selection, I need some cells below to automatically complete. How can I do that? Is it possible with or without VBA?
I have a list of Names that has numbers accumulated over months. I am looking for a formula to use in a search tool that uses a drop down list to identify the name I am looking for and then the formula will show me the increase that happened in certain months.
See the attachment the result is coming from Denominators tab, I want the answer displayed in the Display tab, you will see a drop down list at C3 in Display, I am trying to show the answer in cell D9-I9.
how many the denominator has increased in that month. so for D9 it will come from denominator tab column c minus b, E9 will be d minus c
I've created seven names in my data validation source list on Sheet 3 in the following range of cells, A2-A7. My data drop down validation list is located on Sheet 1, A2 in the same workbook. I would like to trigger a macro based on the name I select in this drop validation drop down list that will fill out an address, telephone number, and email address in the following cells next to my data validation drop down list on Sheet 1: B2, B3, and B4. I want it to be designed so that users will select a name and have that person's corresponding address, telephone number, and email address fill right next to their name on the same sheet.
I have a workbook that has two worksheets. One worksheet is an input worksheet. A user will select a date from a drop-down list and type in the events that occurred on that date in 8 adjacent cells. The user selects a button that advances date and clears form. On sheet 2, whatever was typed into sheet one is saved via VLOOKUP formula. However, if I try to change something retroactively and select a previous date from the drop-down list, it clears everything in sheet 2 that was typed for any selected day.
I am looking to write a code to lock/unlock cells based on values selected using a drop down list (see attached Excel) For example if Netherlands is chosen as the Country (Column A), then except for the columns Amsterdam (column B) and Eindhoven (column C), all other columns must be locked. Similarly, if India is chosen as the country from the drop down list, then only the columns New Delhi and Mumbai must be editable for the user, the rest of the columns remain locked.
I tried tweaking some of the lock/unlock codes around, but got lost especially with getting to run the macro - still trying to come to terms with running a "Private Sub Worksheet_SelectionChange" function in the sheet from "Module"!
I have 3 related dropdown lists that work perfectly, if you enter data from left to right. But, if you click in the cell containing the second list, which is based on the first list, of which nothing has been selected, you can just type any value in the cell. Is there a way to prevent this, or at least validate that what is entered is a value in the list.
I am trying to create a drop down list that is dependent on two criteria. To depict the issue, I've created a mock-example about sports.
On my 'data' sheet: Column 1: Name of sport Column 2: City Column 3: Name of sporting team On my 'form' sheet: Cell 1: Dropdown list to select name of sport Cell 2: Dropdown list to select city Cell 3: I want this cell to be a dropdown list of names of sporting teams, based on the conditions set by Cell 1 & 2.
I am trying to improve a process for someone in my workgroup to save a lot of time when reporting performance.
I have a spreadsheet with a drop down list of names. When I select a name from the drop down list I would like to copy a range of values on another sheet and paste special value a few columns over on the same sheet. I would like to have this only happen for the range of vaules on the row that correspondes with the name that I selected from the drop down list on the original sheet.
Column A Column B Customer ID Suppliers 0023 ABC Co. 0046 XYZ Co. 0023 qqq Co. 0034 MNO Co. 0023 ppp Co.
in another sheet in cell B2 user enters customer code(say 0023).
in cell C2 user is required to enter a single supplier of that customer(0023) from a dropdown list(source customerdb.xls). usually the dropdown list of C2 will show all the suppliers name where i need to show only 0023's suppliers in the dropdown.
so what i need is to filter C2's dropdown list based on customer id entered in cell B2.
fill the column "Level 2 Area" based on the value selected from "Level 1 Area" which is coming from a drop down list. So the "Level 2 Area" will be a drop down list also based on the selected value from the drop down list from "Level 1 Area".
I want to perform a calculation that is based upon user selection from a drop down list. In a simple for instance it would be something like:
Cell A1 has a drop down list containing 'Apples' & 'Oranges'
Cell A2 asks for quantity
Cell A3 needs to have a formula that calculates the price based on the user selection from A1 with each option having different prices (prices set and do not require manual input)
Would an 'If' statement cover this and, if so, what would it be?
Im creating a spreadsheet at work, which has a drop down box with the options of open and closed in it.
I also have a column for length of time of the claim, what i need to do, is now find a way of getting a average length of a claim, but only to see the closed option from the drop down box.
for example,
row 1 open date - 02/06, closed date - 01/07, dropdown box - closed, life - 29 row 2 open date - 10/06, closed date - n/a, dropdown box - open, life - -39400
as you can see from the example above, i cant simply do a average of the whole column, as would read the open ones as well. so is there a way of doing the formula, but telling it to only see the open, or closed ones?
I am trying to copy/extract row of data from worksheet(Detail)A:W to worksheet(1st Letter) if X=1st Letter on worksheet(Detail). I have never used VBA and i am not sure if this can be done with a formula.
I'm new to excel and was trying to make a workbook that will have a drop down list populate based on a user input in two separate cells. Basically, i have columns: name, pages, and books. I would like to have the drop down list match data by first finding the amount of books read, then finding the amount of pages read. Then any name that meets the criteria will be available in the drop down list. How can I do this?
What I am trying to do is have a drop down list in one cell and have the next cell bring in the correct price for the item in the first cell. Sounds fairly easy? Well both lists are 200 items.
I have been trying to do this with just three items so far. On sheet two, I have created two lists. The first list in column A contains dogs, cats, mice. The second list in column B contains 1, 2, 3. On sheet one, I have created the drop down list for the animals in the A12 cell. I would like for B12 to auto populate the corresponding number to the animal without having to create an if formula for each animal and number.
I'm creating a new spreadsheet for different fines we have as a football club.
I have a table frozen at the top which looks like this:
Fine 1 Fine 2 Fine 3 Player 1 Player 2 Player 3
Then also I have a list below this with the date and specific fines:
Date Player Fine Amount (drop down (drop down Entered manually list of players) list of fines)
I am wanting the amount of the fine to be entered into the table at the top of the spreadsheet automatically based on the 2 drop down list entries. I would also need the table to keep adding the fines together once new entries are made.
I am trying to build a report where I can chart data base on a dropdown selection.I did build the dropdown lists, however I don't have any expertise on execel functions in order to make it work.I am attaching my draft report.
I have a spread sheet that has three sheets, PROJECTS - TIMES - LISTS Time sheet.xlsx PROJECTS contains a list of 'In Progress' and 'completed' projects for work, with relevant other data, I.e. PROJECT No. / STATUS etc This will grow to 1,000's of rows TIMES will contain the amount of time a person spends on a PROJECT on a daily basis. This will grow to 10,000's of rows LISTS contain basic validation list for the first 2 sheets.
Part A I would like to have a validation drop down list for the PROJECT NO column in the TIMES sheet that only lists the PROJECT NO from the PROJECTS sheet where STATUS <> COMPLETED. I.e. I only want to display the PROJECT NO's for current projects.
Part B Even though I only want the PROJECT NO used, can the drop down list also contain other column's data for reference information only before one is selected.
I have a drop down list with 6 recipes. When I select chocolate for example I want that to automatically populate different cells in the worksheet based on a standard I have created for that recipe. The recipes won't change they just have different ingredients and I want that to show up depending on what I select on the drop down list. I went into VBA and worked a little with this starting code:
If Target.Address = "$F$3" Then Target.Offset(0, 1).Value = "1"
but It wouldn't populate separately based on what I had selected in the drop down it would just populate all 6 recipes the same.
I have a column of 343 items in E, and their corresponding prices in Row E. I've created a drop down list in numerous cells in Column A for items, and I need to formulate it so that the adjacent cell in Column B for each individual drop down will call the correct prices from E.
I have seen a few threads here about this, but not for how I need it to work.
I will have a drop down list with 8 options, (Days of the week Wed to Wed, hence the 8 days lol) There will now be 8 columns, one for each day.
I want to be able to select the day from the list, and then have it hide all the columns except for the day selected. When a different day is picked, un hide that one and hide the rest.
Is it possible to update certain rows only based on the choice selected from a dropdown list
I shall explain this scenario
I have attached a small excel sheet called TESTTHEM which i'm testing and learning excel simultaneously. On the attached sheet
If i select a value in B4 as BusinessLogic, it should then lookup for relevent rows in MISC worksheet and copy C5:L5 from MISC worksheet and replace the columns G4:P4
I've created drop-down lists in cells B3 and B4 (this is in worksheet 1), based on a column in Worksheet 2. I'd like Worksheet 2 to autofilter the data based on the drop-downs in B3 or B4, or both together.
I am a newbie to Excel. I really appreciate if someone could help me here and this is very urgent as I have a project going on.
I have a cell say B3, which is a dropdown list I created using Data Validation. It only lists down Yes or No.
What I need is when you click on Yes in B3, i need columns C to I to unhide. If answer is No, column C to I should be hidden. By default, the columns will be hidden.
Can you please help? I tried many times but not successful. Appreciate if someone will be able to walk me through details. If you want to see the sample spreadsheet, I can sent it to you by email. I tried Data> Outline group but they are not happy with this.
