Quote Originally Posted by ResulG
Hi Guys,

Recently I downloaded a zip file that had a data validation. I have been looking for it again but cannot find it.
It did this.
It had a selection of vegetables and fruit.
If you selected veg in the first column, it then gave you a selection of veg in the second column and if you selected fruit in the first column, it then gave you a selection of fruit in the second column.

Does anyone remember this and send me the link to the original thread please?

Thanks in advance

ResulG
Try

http://www.excelforum.com/showthread.php?t=581686

---