data validation dropdown

Hi, I'm trying to create a stock inventory management sheet and unfortunatly am failing at my first hurdle. I am trying to get cascading drop downs working in an excel sheet but am struggling to figure out how to have my drop down filtered on the results of a drop down to the left of it. My...

Hi there, and thanks for looking at my issue for me. I have a workbook that has a sheet called DATA. On that sheet I want a code that will revise the data validation dropdown value in column AH from it's blank default to EASY WIN, but only if the value in column B says NO SHOW and the date...

Hi everyone, I have data with list of departments. I want to create a dependent data validation for user choose to input information (exp list of values in center depends on value in division) I have try formula Filter but it doest work in data validation or Indirect (not suitable with list of...

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