Create a validation list in E2 pending on D2

[Rocky2013]

Hello,
I'm looking for help to lookup a value (D2) then list the sub -range in the validation (E2).
If I change the value in D2, the list in E2 will be automaticly update including the change
cell content.


I like if this can be done using function something liked array formular (I think). I like
have soultion for using VBA as well.


Thanks

[smuzoen]

You could use a Worksheet_Change event to fire off a Autofilter and then use the results of the autofilter to create the drop down validation list - see attached workbook. The only catch is that you would need to have the list ordered in Column A otherwise a different approach would be required.

[Rocky2013]

Hello,
Thanks a lot, you make it very simple. And it works, realy helps!!
That 's right I like this forum.

Thanks