HOW DO I CREATE LISTS WITH CELL REFERANCE RULES

[Debra Dalgleish]

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

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:

 

[luke013]

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

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]

You can create dependent data validation lists. There are instructions here:

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