All Hokie, All the Time. Period. Presented by

The Lounge Board

Technocrat

Joined: 10/07/1999 Posts: 20717
Likes: 6741

What's this?

Excel Grand Wizards - need assistance


I have two columns of drop downs and I would like to make the second column conditional to what is selected in the first column. For example in Column A if I select Value 1, only A,B or C are available to select in column B. If I select Value 2, only D, E or F are available to select. I haven't figured it out. Do I need to write a macro? Any other suggestion? Will provide a tip. Thanks.




[Post edited by Technocrat at 06/28/2017 09:05AM]

Posted: 06/28/2017 at 09:00AM


+0

Insert a Link

Enter the title of the link here:


Enter the full web address of the link here -- include the "http://" part:


75
Hide This

Current Thread:
 
  Excel Grand Wizards - need assistance -- Technocrat 06/28/2017 09:00AM
  Go to Data Validation, as you are making a list, then use an IF,THEN -- CochraneResident 06/28/2017 09:38AM
  Much grass ** -- Technocrat 06/28/2017 10:02AM

Tech Sideline is Presented By:

Our Sponsors








vm307