data validation (list)

Hello Everyone, I am facing a critical problem which I believe require macro to solve this problem. I tried to create the macro so many times but it is not working and not solving my problems. Really appreciate is some body helps me to solve this problem In a worksheet I implied data...

Hello Everyone, I am facing a critical problem which I believe require macro to solve this problem. I tried to create the macro so many times but it is not working and not solving my problems. Really appreciate is some body helps me to solve this problem In a worksheet I implied data...

I am filling out a list of capabilities that have sub-capabilities. A2 is the Capabilty Name A3 is the Sub-Capability name B2 is drop down list (data validation ) with selections of "Yes", "No", or "N/A" In B3 I am trying to create an IF Statement where if B2="YES" then I am presented with a...

I am filling out a list of capabilities that have sub-capabilities. A2 is the Capabilty Name A3 is the Sub-Capability name B2 is drop down list (data validation ) with selections of "Yes", "No", or "N/A" In B3 I am trying to create an IF Statement where if B2="YES" then I am presented with a...

I am trying to Print to PDF from a data validation list. I have a pay summary sheet that auto fills when i select the employees name from a drop down list in Cell C6. I need to be able to print off each persons pay summary without having to manually select each persons name Currently i have a...

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...