#datavalidation

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

In F5 ,I have a List. if any one select this values "Book1","Book2" and "Book3".. i have to show some error using data validation "=OR((F5<>"Book1"),(F5<>"Book2"),(F5<>"Book3"))" why this code is not working??

Hi, I'm currently stuck on my formula for this project. So, I have to cells that both already have a drop down list. What I want to happen is when you choose from the drop down of Cell A, Cell B will be disable. For example: in Cell A the list is: Cat, Dog, Mouse in Cell B the list is: Cheese...

I have a two-page workbook. A sheet with tab. “LIST” holds a sort of dictionary: Column A holds technical terms. In a given Row, columns to the right of Column A hold related terms. For Example: LIST A B C D E 1 Decibel Sound Power 2 Die Bushing Punch Holder Die Shoe...

Hi ! Good Day I am new at excel, I want to have a data validation list that show a group of list. For example: I have a Departments, now if I click cells below of Departments and choose list of Departments. I want to fill automatic the sections under that Department. Is it possible?

Hi Everyone, I found this macro which allows me to only allow copy-paste values in order for data validation to work. However, this is only one cell. How can i convert to make it work for a range of cells? Private Sub Worksheet_Change(ByVal Target As Range) Dim IsDV As Boolean If...