Data validation lists in adjacent cells

[Guest]

If a value is selected from a drop down list in, say, I7, I would then
require another list in J7 to become unavailable to select from and vice
versa.
How can I achieve this?

Thanks guys,

 

[dan dungan]

Have a look at:

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