Data validation lists in adjacent cells
 

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,
--
Traa Dy Liooar

Jock

Data validation lists in adjacent cells
 

Have a look at:

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

On Oct 9, 9:31 am, Jock wrote:
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,
--
Traa Dy Liooar

Jock