Forum Discussion
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...
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.
No VBA needed. See the attached version.
HansVogelaar,
Can you please let me know the steps you have performed to achieve this.
It will be great help, if we achieve same without using the table format in Template Sheet. ( It may include several other columns).
Thanks,
Muneendra.
Can you please let me know the steps you have performed to achieve this.
It will be great help, if we achieve same without using the table format in Template Sheet. ( It may include several other columns).
Thanks,
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.
- Hi HansVogelaar,
Thanks alot for your kind help. My excel may hold more than 10K rows, will it perform faster?Excel should be able to handle that, but you'll have to try it yourself.