data validation (list)

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

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