data validation (list)

I have 3 Different worksheets within the same workbook. Worksheet 1 contains this Table 1 Table Header is "System"(Not full table): All Systems are entered by hand. <colgroup><col style="width: 191px"></colgroup><tbody> System 16 C URSAE MAJORIS 169 G. Canis Majoris 18 PUPPIS 19...

Hello, Wanted to know if there is a way to use Options (form) button that changes the type of Data Validation List that appears? Also if there is a way to use the same option button to hide or show certain cells based on the options chosen? Example: User chooses A or B using Option (Forms)...

I am trying to build an interactive form in excel. I have most items working as I need, but have come upon an issue that has me stumped. I have a list of structures (Column D) with a series of columns next to it. Each column is representative of one of the options for that structure. Not all...

Hello Is there a way to import a linked column of data that has an associated data validation drop down into word, make the edits in word using the drop down feature, and then having it automatically update the excel file? The background... I am looking to make QaQc easier for my field...

I have 2 VBA codes that i would like both to run when making a selection from a data validation drop down box. Could you please help me incorporate both so they will work. This code will let me select more than one item in a data validation drop down box. Private Sub Worksheet_Change(ByVal...

Hi all: I need some help here. First time poster.. I need help with my dropdown lists, returning multiple values attached to each entry. If I fill down my formulas it only returns one value; not the list attached. Please PM me if you know an easy fix. Thanks ! :confused:

Hey guys and gals. (i am new to this, so don't judge) So here is my question... I am using data validation list setting for a drop down menu (referencing the list in another sheet) - what i want to happen is if one f the values is selected it would generate a value correlated to that... that...

Hello I created a list data validation to a range of cells using =INDIRECT(SUBSTITUTE($D3," ","_")), and it works great, I do understand that there is a limitation that data validation only works with user enter values, however I need to populate the range with a Copy/Paste, so what I need, if...

Hi all, Is it possible to have excel display a chart based on a selection from a list data validation rule. I have 20 charts that I want to be able to view, but I don't want to see all of them at once. If there is a non-VBA solution, that would be ideal. Thank you in advance for your help...

I have used the following VBA script to Print a data validation list: Sub PrintSideBySide() Dim strValidationRange As String Dim rngValidation As Range Dim rngDepartment As Range ' Turn off screen updating Application.ScreenUpdating = False ' Identify the...

Hi All, I looked around quite a bit, but could not find an answer to my question. If this is addressed somewhere else, I apologize. Basically, I have a macro that copies sheets to another workbook, among other things. The problem is that when the cells with drop-down menus are copied, the data...

Ok, I have been searching all over the place to an answer to this problem. I am using a =IF(A1=5,List1,IF(A1=2,List2,"")) style data validation function for my lists. It is, and has been, working perfectly. Today I was asked to add another option to generate a new list. Should be easy. I...

Hi, I want to create data validation with Tick & Cross sign. Is there any options to use Tick & Cross sign in data validation. Please suggest ASAP. Thanks in advance.

I may need some help: I am using data validation in a worksheet using an indirect list (Data Validation in Column D is =INDIRECT($A2), which brings back a list to choose from 100 options. IS it possible to limit this list if the option has already been chosen previously in the column? Example...

Hello Everyone!.. This is a bit challenging for me so i was wondering if anyone can help me out with this. I have read lots of threads about DV autocompletion and people wanting to have in it. Well my question is somewhere in the same field. I have 2 active sheets where one is has a DV based...

I wouldn’t ask you if I wasn’t desperate but does anyone know if it is possible to do the following in data validation: =if(animal = “cat”, ‘list a’, enter any value) List a: this is a list of possible numbers allowed (drop down list) Enter any value: I want the person to be able to put...

Hi Experts, I'm new here..... Here is my problem: I'm using a list as data validation in some cells. I want to have one value in one cell only and that the values should not be repeated. So for example, if the list has three names: Dave, John, Patrick, the user should be able to select each of...

Hi. I was trying to create a drop down list, where the user could select multiple options from the list, but still the options selected must be unique within a Cell. For Instance: if a Dropdown has A, B, C as values, selecting A and C is a valid selection, but selecting A, C and A is not. I...

Hi I have made a cell give two options ye or no in excel 2013using Data Validation. Now when I copy paste a value other than yes or no on that cell I want an error shown. Right now it just over writes the data validation. How do I achieve this without macros Thanks, Hemanth

Hey Guys! I own a valet parking company :) I have a list for the guys that says which day of the week they are available to work. I have a list for the guys that says which accounts they have been trained at. I would like to have a data validation drop down list that cross references the 2...