data validation (list)

Hello All, Trying to see if this is possible. What I have: Excel sheet - Has a cell with data validation (List). Below that I have a graph. Below the graph I have a table that is based on the selection from the List. What I look to do: Take those 3 items mentioned above and insert into a...

Hi All, This is my first time on the forum and hope everyone is enjoying the new year. I am using Excel 2016 and creating an estimating workbook. To simplify my question I'll use the following example. I have created a table called Inventory as shown below. <tbody> A B C D CATEGORY ITEM...

I have table containing questions and multiple responses for each question (table format as below). I want to convert these responses as drop down list (without blanks) for each question. Data validation list is giving me drop down with blanks. How do I remove blanks. Since I have 50 questions...

hello, Can anyone please send me there suggestions on how to automatically populate a range of columns. As of now, I have a manually created reference chart located on sheet 1: <tbody> * B C D E F G H I J K L M N 3 * ALBANIA ALGERIA ARGENTINA ARMENIA AUSTRALIA...

Scouring through the internet, watched many videos, and read a few other articles, (one which i thought would help but they were using Open Office, and I didn't feel like downloading it just to view 1 file, and my luck it not be helpful) anyways... I have 4 sheets. Sheet 1 is my...

=IF(C10="01", "No Sub Project", IF(C10="03", "Sub Project 1", IF(C10="04", "Sub Project 2", IF(C10="05","Sub Project 3", IF(C10="06", "Sub Project 4", IF(C10="07", "Sub Project 5", IF(C10="08", "Sub Project 6", IF(C10="09", "Sub Project 7", IF(C10="13", "Sub Project 8", IF(C10="14", "Sub Project...

I have a dropdown that gets its reference indirectly from another cell. The referenced list is a table column that will contain any digit from 1 to 9 but not necessarily all of them and some will appear more than once. I can find lots of way to extract those unique values but This would mean...

I am creating a Dashboard to display some of the highlights of my data that is being collected. On this Dashboard I want to display the TOP FIVE players based on a their respective scores. But I want to be able to use a Data Validation drop down list to select a certain Project Player Position...

Hi All, I have encounter an error, while using dynamic data validation list, and adapt it to combobox list. it only works for only common data validation list. the list placed on different sheet : for the dynamic data validation list, I'm using formula ...

I have a data validation drop down list with a list of over 100 names. When a name is selected from the list, data populates in a table below that displays a snapshot of weekly productivity for that individual. I want to create a vba macro to do the following: For each name in the range that...

Excel Wizards, I am looking for a way to make a dynamic list for a subset of values and another list for another subset. For example- take the below data: <tbody> Customer Rank Customer1 [B2] Customer1 [B3] Customer1 [B4] Customer2 [B5] Customer2 [B6] Customer3 [B7] Customer3...

The code below is used to go through a range of values looking for the first cell that is < 0. It then inputs a Data Validation list, Lengths_7000. The cell is given a default value, but I want to capture the address of where the validation list was entered to be used in the code later. Any...

Hi, I'm really struggling with how to solve a problem I have. What I have is: A spreadsheet that contains different rugby clubs per age group. A defined drop-down list of those clubs in cell D3 Conditional formatting to highlight the clubs based on the drop-down value selected The situation...

Hello, I am trying to set up some conditional data validation for a questionnaire type template. Each question will have an Index number and the various allowable answers will be on a separate tab. Previously, I have set up a similar data validation with the following format and calculation...

Hello dear Excel experts. I am working on an Excel file that will be used for time management. I have 3 columns like the ones below (each column is a named range) in the Control worksheet: <tbody> D E F 1 Actions Project Proposal 2 Project Project1 Proposal1 3 Proposal Project2...

Hi I am trying to do a data validation list where only the on the form below where if I mark a one in any of the columns in blue I only get these result from my data validation list rather than them all. So if I have a 1 in Type Specific and Land Reg columns then on the same row under...

Hi all, Newbie here in need of some help..... I have a cell which is a data validation dropdown that will eventually contain a lot of values. What I am trying to do is make this multi-select. I have already entered some code to make it multi-select but in the following format: Value1, Value2...

I'm using the following code to clear different lists in different cells: However, all of them work except for If Target = Range("T5")... which clears all the data validation lists instead of just T6 and T9. Private Sub Worksheet_Change(ByVal Target As Range) On Error Resume Next If Target =...

Hello Friends, This is my first post so please let me know if my query is not clear to understand. I am novice user of excel. I am creating data validation i.e. drop down list for the service "Spa" 1)Select Specialist Gender (Lets select Male) 2)Select Specialist (this should only show names...

All, I am completely stumped. I would rather not use VBA or Macros for this problem, but understand if that will make things a lot easier. This may be a simple formula, but I have been struggling to figure this one out. Here's the information. I am trying to auto create a table based on the...