validation list

Hello I'm working on enhancing my xls where currently, I use a Vlookup to show SurName (Col J), FirstName (Col K), Rate (Col M) and Hours (Col N) based on knowing a unique ID. So formula used in Col A is =IFERROR(VLOOKUP($L1,Personnel,2,FALSE),"") where L1= a unique ID, Personnel = table range...

I´m working on a formula for a validation list. What I´m doing is: User chooses the month: May ( for example - the drop down has all 12 months ) Once the month is choosen - there is a second drop down list with the days of that specific month. I´ve named range all the months My problem: The...

Hi guys, Is there a way to have a formula or a VBA code associated to the choice of any value in a Validation list. For example is there a way to have lets say in A1 a validation list and to have B2 returning the username of the person of who will select a value in A1? As ususal thanks in...

Dear All following is my data <colgroup><col><col><col></colgroup><tbody> CODE MATERIAL 1 MATERIAL 2 111 150 X 215 400X00 123 150 X 215 124 500 C 1 112 150 X 215 24.5 </tbody> MY QUERY IS When I enter Code in one cell., then the other cell validation list only contain material...

I am in need of a formula that will allow a value in a drop down list to be used only once in a row. List located D200-D876 So row D10 through J10 will all use this list (D200:D876) but the value cannot be allowed to duplicate within the row. I will need to repeat this function for each row...

Hi all, I'm having an issue with context-based validation. Basically I have a spreadsheet where I want the data validation drop-down list in column B to be based on the selected value from the drop down in column A. So, for example, if the drop down in column A gives you the values X, Y, and...

Hi everyone, In the following extract, I would like to have today's date placed into Col K when an entry is made into Col J. Entry into Col J is from a validation list of 3 options. What I desire is that when one of these options is selected ("Complete"), then I would like today's date to be...

I have to prepare 70+ tables from a data set. In order to take the same information from the data set, I have created a validation list dropdown (in cell A2). The next step (that I need help with) is recording a macro that prints the first table, then selects the next item on the list and prints...

Hi everyone, I have the following "Summary" sheet - the start of a basic dashboard i suppose you could say. Excel WorkbookDEFGHIJKL9SectionIdea CategoryIdea typeStatusPlanned SavingSavings to Date10DistributionSV28 - Shut Down Capital (above) 500KCost SavingStartedJuly 2012$...

Right now I have a code that is working great (Which I got from this site) :) I need help to modify it to do something else. I have a button that cycles through my validation list and creates PDF file for each value on the validation list. My validation list is short for this post...

I'm trying to use Validation > List to allow my sister to easily input scores into her school gradebook. Cell B1 contains the total possible correct answers for a test. This number changes every week. Cell C1 is where she will input the number of correct answers from Student 1. I would like to...

Greetings, I need a little help and I think this is the best place to get it. I recently added some VBA code to a spreadsheet to provide a dynamic search of Validation Lists. The code works great except for two issues incurred afterward: 1. I lost the ability to copy and paste items on the...

I have a cell where I need to have a validation list. The issue is I want the validation list to change based upon an option button selection. For example, if "Option Button 1" is selected, I want "Validation List 1" to show up. If "Option Button 2" is selected, I want "Validation List 2" to...

Hi! How can I review all validations in a sheet (Excel 2007) similarly to conditional formatting where I can show everything in a sheet? pi

I have created a dynamic data validation list in a worksheet, using nested IF statements and named ranges. The list shows up just fine, however, I am not getting an error when I enter invalid data. I've checked to make sure the error alert is enabled and recreated the data validation a few times...

I am trying to find a way to create a validation list where the source is linked to a list that has duplicates. All of the duplicates are bundled together and I do not want to remove the duplicates from the source. I just want to remove them from the drop down list. Source:$A$1:$A$10 List...

Hi people smarter than me :)! I've got a very complex sheet with a ton of validation lists. These lists have many dependent variables, and when it comes time to select from a specific list, there are usually only 1-2 options to choose from. I would like to create a macro (or some other...

I am writing an application in vba for excel and need to set the validation list for each cell in a specific column. I have the following code to do this: Public Sub setReviewerCellValidation(reviewers() As String) Dim str As String Dim cnt As Integer For cnt = 0 To...

In Office 2007/2008, I was able to use the following formula to create a list for data validation: =INDEX(B2:B79,MATCH(TRUE,B2:B79<>B2,0)-1):INDEX(B2:B79,MATCH(TRUE,B2:B79<>B2,0)) My B column contains 2 unique values, so this chose 2 next to each other that had different values. In Excel 2010...

What I want to do is create a validation list that lists the names of all the excel files in a specific folder. Then I want another validation list that lists all the worksheets in that excel file. Is something like this possible? I would like to implement it on a spreadsheet I am working on...