data validation list

On one worksheet I have a table such as the table below. On another worksheet I have a bunch of lookups that are based off a couple of unique values. Name is repeating, but identifier is not. On another sheet, I need a dynamic drop-down list of all identifiers for a given name. For example, if...

I have created template using data validation drop down lists used to select items relevant for a job quote. Not all items on the list will be selected at any one time so there will some blank lines left over. I would like to extract this information and send it to another formatted sheet in...

Guys, I don't know how to do it without VBA - hopefully you know better. Situation: I need two kind of inputs from user. First - to indicate number of unique VAT rates that are on the invoice. Any integer between 0 and 4 is allowed. Let's assume that user selected 3. Now Excel knows that there...

I have a dataset in five columns (Let's call the headers "Claim Stage 1, Claim Stage 2, Claim Stage 3, Claim Stage 4, Claim Stage 5"). Under each header, I have 100 data options to choose from. What I'd like to do is have two drop-down data validation lists where the second is dependent on the...

Hi All, <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I have a data validation range that includes cells that have no data yet and it shows up on the drop down list as empty space, is there a way to prevent it from appearing in the drop down list until...

I know this should be easy but it's not working. Basically, I have a schedule for training with 30 minute time slots from 8 a.m. to 4:30 a.m. In Column M, starting with M4:M15, I have a list of activities B4 needs to have data validation with the contents of M4:M15 applying conditional...

I need to put together a worksheet that assists users in selecting a valid account for posting activity. Prior to viewing a list of acceptable account numbers (with full descriptions), the user must 1st select from 4 other drop downs. Column A has 2 possible selections Column B has 2 possible...

Here's my question: I created a data validation on my excel sheet, is there a way to make the fonts on the drop down list bigger or even change the fonts?

I have a dropdown list in my spreadsheet that identifes a code. The code does not mean anything to the users of the spreadsheet so I want to include a description with each item on the list, BUT I do not want this description to be included when the user selects the code. For example, I want...

Need help with nesting and data validation BASIC BACKGROUND INFO: I have a spreadsheet that I am doing data validation with multiple dependent lists. I have setup a validation list for my first instance, and for my second instance, instead of using the 'Indirect()' command, I decided to do a...

Hi, First I want to say i'm new to this forum and already it has been a great help. Looks like there are a lot of really experienced people on here. I have a few cells that use data validation to generate a drop down lists from ranges elsewhere on the sheet. Some of those cells are dependent...

Hello, I am using win7 64 and Excel 07. I have 2 sheets of data. Sheet2 is a table listing data in rows for a column of 20 different items. Each item has 19 different values associated with it (if that matters). On sheet 1, I want to create a similar smaller table with 5 drop downs that...

Does anyone know how to remove duplicates from a list created with a dynamic named range? I have a drop down box with a list on sheet1 that is based on a dynamic named range called customer_names on sheet2. Users on sheet1 can either select a name from the drop down list or enter a new name...

I'm using MS Excel 2000. Is there any way I can use autofilter and data validation list to sort and filter information (from a different sheet from other than orginal) and dynamically update and display it on another? Scenario: I have three sheets, one called Dashboard, Summary of All, and...

I am trying to do what seems to be easy enough but I can not figure it out. Excel 2007 Scenario: I have a fairly large budget spreadsheet and there are money categories in column E. The categories are in a drop down using simple data validation (Federal, State, Transfer, etc.). I have a money...

Hi Guys! I have just added the data validation-function (list) in a cell linked to another sheet. Lets say I have values such as "1234 Horse", "2345 Cow", "3456 Pig" and so on... Is it it possible to automatically "cut off" the characters following the four digits after it is selected into...

:) Hi everyone, Currently facing a roadblock with a drop down list data validation approach and is seeking for alternatives. The issue lies with the data list where options contains as much as 415 characters in total. Traditional data validation list only displays 255 characters and I've...

Hey Excellers... I have some dynamic named ranges in sheet1, and in sheet2 I have data validation dropdown list which has the names of all the DNR's in it. What I want it to do (in sheet3, no less) is for the user to be able to pick a named range from the dropdown list, and have a particular...

Hello... does anyone know how to make a list data validation pick the information you want from your list by typing the first letter. For example.... autofilters allow only 1000 entries to be displayed. You can choose or "fast forward" to what you are looking for from the autofilter drop down...