You can create dependent data validation lists. There are instructions he

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

luke013 wrote:

"Debra Dalgleish" wrote:


I'm not sure what you want to do. If you're trying to document data
validation that's been applied, there's code he

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

If that's not it, perhaps you could provide more details, and someone
may be able to help.

luke013 wrote:
i have a spreadsheet with a validation list, and used vlookup to drag in other information that goes with that cell. i need a column that refers to one of the vlookup cells, bu gives a list of input options that match the information in the referance cell. is this possible??


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html