CODEWITHSUNDEEP
excelexcel-formulaexcel-2010
Taha Rehman Siddiqui
Taha Rehman Siddiqui

Reputation: 2533

Excel Data Validation Source for different columns

I am making a series of cascading dropdowns in Excel. When a user selects an option in ColumnB, the sheet finds a list "Name"d = ColumnB value and set the validation for that column with that list.

Data Validation

It is working fine

Options Loaded

But when I drag the cell in the whole column and try applying the Data Validation property to all cells, instead of selecting the previous cells respectively, it is defining every Data Validation property with the specific cell with which the first cell was binded.

Data Validation source for another cell

It is not much of a problem as I can do that for individual cell, but I will be setting the data and names through code later, so I need to find a way that every Data Validation source contains a reference to its previous cell instead of that one specific cell.

Upvotes: 0

Views: 375

Answers (1)

alex.pulver
alex.pulver

Reputation: 2125

Remove the $ sign. $ sign means that the reference is absolute and the cell reference in the formulas won't change when the cell is dragged or copied.

Another solution is to define the data validation for the entire column and you don't have to drag anymore.

Upvotes: 1

Related Questions