data validation dropdown

I have a spreadsheet that we are trying to build dependent dropdowns for several values. Column A is the 34 Organizations. Each of those 34 Organizations has a unique list of Owners, Departments, Areas, and Accounts. I have limited the the sample file to 10 organizations. The desire is to be...

Hi, I am trying to create a multiple dependent dynamic data validation in multiple rows. I have tried doing it through name table / Indirect Function and it's working only in the first row. In the Second Row (Column 1) when I am selecting different data, in that case in Column 2 its still...

Hello, I am trying to create a column where there is a drop down list in each cell and have the ability to select multiple options. I know how to get the drop down list with data validation and I found this page that allows me to successfully select multiple (without repetition) with a VBA...

I am trying to set up data validation for a report, but two columns aren't flagging blank cells they it should. The "Blank" list is the title and one blank cell below it. The AcceptReason has four selections below the title, and the RejectReason has ten. Column I has data validation for...

Hi All, I have tried option to use validations list using Indirect/Vlookup, and its seems no results in Vlookup using. Source - Entry Table UniqueErrorField ErrorField ErrorsNoted Age Age TOP BOX - Wrong Age APS Date Range APS Date Range TOP BOX - Wrong Entry BP History APS Date Range...

Hello Experts, i have below data , "Name , Department & salary". i need your help to apply filter in "D" with dropdown for Department i.e. if i select HR then below table should display only HR related details.. D A B C Name Department Salary ABC SCM 193...

I'm using multiple columns to place each employee where they are scheduled. I have the list of employees on a different tab labeled employees from a3:a62. Thank you

I have a macro that I'm using to copy two sheets from one work book to another workbook. The copy works - what doesn't work is copying the data validation that I have on one of the sheets where it has a drop down list based on the other sheet? Any suggestions to make this also copy along with...

Hi All. This is a bit of mystery. In a macro I place Data validation Dropdown in to a range. I am using this bit of code for this: 'Adding the Data validation listboxes to ***listrange*** With listrange.Validation .Delete...