PC Review


Reply
Thread Tools Rate Thread

Data validation lists in adjacent cells

 
 
=?Utf-8?B?Sm9jaw==?=
Guest
Posts: n/a
 
      9th Oct 2007
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
 
Reply With Quote
 
 
 
 
dan dungan
Guest
Posts: n/a
 
      9th Oct 2007
Have a look at:

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

On Oct 9, 9:31 am, Jock <J...@discussions.microsoft.com> 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



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Use data fed in adjacent cells to sort and copy the data to spec named range sri_gs Microsoft Excel Discussion 0 12th Apr 2010 02:07 PM
Locked Cells with Data Validation Drop Down Lists Joe D Microsoft Excel Misc 2 19th May 2008 03:44 PM
Data Validation to restrict blank value in adjacent field =?Utf-8?B?Sm9obiBTLiBMYWJhcmdl?= Microsoft Excel Misc 5 17th Aug 2007 09:33 PM
Data validation with validation lists and combo boxs =?Utf-8?B?S2VpdGg=?= Microsoft Excel Misc 1 12th Oct 2006 11:08 AM
Cells with Validation lists attached =?Utf-8?B?TWlrZQ==?= Microsoft Excel Discussion 1 5th Apr 2006 05:14 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:36 AM.