Hi,
I've created a dependent list in Excel using Data validation. The first
list is independent and the second list depends on the first list. I'm
facing one problem in this. After selecting a element in first list and
corresponding element in second list, if I want to change the first list
again, I can go and change the value. But the value in the second list
remains the same. I want the second list to be empty when I' selecting
the first list again. How can I do this?

Thanks in advance

Regards,
Rajesh


--
rajeshkumar
------------------------------------------------------------------------
rajeshkumar's Profile: http://www.excelforum.com/member.php...o&userid=24672
View this thread: http://www.excelforum.com/showthread...hreadid=382451