Go Back   Tech Support Forum > Microsoft Support > Microsoft Office support

        
Join Tech Support Forum Today

Closed Thread
 
Thread Tools Search this Thread


Old 04-10-2012, 08:44 PM   #1
Registered Member
 
Join Date: Apr 2012
Posts: 1
OS: windows7


Mandatory cell input with drop down menue

Hello all,

I know there have been posts about mandatory cell input. So far, I haven't found a solution to my problem, though.

I have a dropdown menue in column L. If the user chooses a certain value of the dropdown menue, I want him to fill in the cell in column M, too.

How can I do this?

Thanks,
Hermann

__________________
Hermann3 is offline  
Old 04-11-2012, 04:24 AM   #2
Registered Member
 
wampyra's Avatar
 
Join Date: Apr 2012
Location: Belgrade, Serbia
Posts: 40
OS: Win7 Ultimate 64bit, Ubuntu (Natty Narwhal), Mac OS X v10.7 (Lion)

My System

Re: Mandatory cell input with drop down menue

Select the column M and in data section click on Data Validation.
Depending on what you need go through the options... Everything is mostly self explanatory.

HTH
__________________
wampyra is offline  
Closed Thread

Thread Tools Search this Thread
Search this Thread:

Advanced Search

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 Off
Pingbacks are Off
Refbacks are Off


Post a Question




All times are GMT -7. The time now is 05:16 AM.


Copyright 2001 - 2012, Tech Support Forum

Windows 7 - Windows XP - Windows Vista - Trojan Removal - Spyware Removal - Virus Removal - Networking - Security