Hi everyone,
I'm working on an excel file in which I have to validate one cell when it satisfies a condition in the other cell.
For instance, if cell A is 1, then cell B should be validated to a, b, c (Incelldropdown).
I have tried it through wizard (in excel menu bar "data > validation>custom"), but the limitation is upto 7 IF loops, where as I need at least 16 loops to get my work done.
Trying through VBA, but not working out properly (probably because of my lack of experience in it).
Can anybody please help me out with this..!!!
A lot of thanks in advance..!!
I'm working on an excel file in which I have to validate one cell when it satisfies a condition in the other cell.
For instance, if cell A is 1, then cell B should be validated to a, b, c (Incelldropdown).
I have tried it through wizard (in excel menu bar "data > validation>custom"), but the limitation is upto 7 IF loops, where as I need at least 16 loops to get my work done.
Trying through VBA, but not working out properly (probably because of my lack of experience in it).
Can anybody please help me out with this..!!!
A lot of thanks in advance..!!