Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

I need to populate a data validation drop down box with multiple choices based on a cell value of the adjacent cell.

0

I need to be able to do a vlookup of a cell, using the result, create a Data Validation drop down box that has multiple choices from a seperate sheet. Ex

Sheet1                                 Sheet2

 A                B                         A          B

1. Steve     Here                   Steve    DV Box with Here, There, Everywhere      as choices

2. Steve     There                 Bob       DV box with Going, Gone                         as choices

3. Steve     Everywhere

4. Bob        Going

5. Bob        Gone

This is a very very long list on Sheet1, Column's A & B .    

I hope this makes sense.                      

Answer
Discuss



Answer the Question

You must create an account to use the forum. Create an Account or Login