Difficult one..

[VeKa27]

Hi you all,

Because i cannot insert a sample document, i will try to explain my problem..

Suppose you have an Excel sheet. In column A (from A1 till A20) you have text and number data (A1= Option 1, A2 = Option 2, ...).
In column B you put 20 drop-down lists that refer to column A. So if you click in cell B1 (or B2, or B3,...) you get a dropdownlist and you can select "Option 1" till "Option 20").
So far so good. But now comes my problem.
This is what i want to happen: If i select in cell B2 also 'Option 1' (same as in A1) then i want that all cells from B3 till B20 refreshes and gives as result "Option 2, Option 3,... till Option 19 then".
Simple explaining is, every cell from B2 till B20 has to look to the cell above and has to give a +1 result. And those drop-downlists has to be available in all cells B1-B20.
The top of the bill will be that also the drop-downlist refreshes an gives only the Options for selection under the cell above. For example if in cell B10 "Option 5" is selected, cell B11 gives only a list of "Option 6 till Option 20". (but that is no need)

I hope you all see what i mean an i hope someone will be smarter than me..
Thanks in advance

 

[MickG]

Try changing the cell address below:-

 Range("D" & Target.Offset(1).Row & ":[COLOR="#FF0000"][B] D36[/B][/COLOR]").Offset(, 1).ClearContents

 

[VeKa27]

Alright! Now it is completely as i hoped. Mick, with much respect i have to thank you for your help.
You are great..

 

[MickG]

You're welcome
Glad its working for you !!