Hi,

You need VBA, cannot help you here. The closest I have seen to your requirement is...

http://www.contextures.com/xldataval02.html

It is a dependant list. But you would still need to select second list, and this is based on the first list.

Sorry I cannot help more on this occasion.