Forum Discussion

Muneendra's avatar
Muneendra
Copper Contributor
Jun 14, 2021
Solved

Fetching multiple match values and display in drop down using VBA

Hi All,   I am new to VBA, Please help me on below.   I have three sheets in my Excel ( Template, Vendor ID, Vendor Location). Template sheet have the three columns ( Vendor ID, Vendor Name, Loc...
excel
Macros and VBA
office 365
  • HansVogelaar's avatar
    HansVogelaar
    Jun 14, 2021

    Muneendra 

    I created a few named ranges - see Formulas >Name Manager.

    I used these names in Data Validation rules for column A and C.

    It is not essential that the data on the Template sheet are in table format. See the attached version.

Resources