VBA - Dynamic Data Validation based on a category

Hello All,

I have 2 columns,1) Category 2) products.

I Have another sheet where it has all the Category and I would like to create a VBA which will create a dropdown of all the products corresponding to each of these category.

I have created a fixed list data validation VBA code before but this is dynamic and the list is based on category, so I would like to have your inputs on this problem.

I have attached the excel to explain the problem

Thanks

Thanks for the message.

I would like to place a data Validation against those Category using Drop down list.

The idea is that the users wil select one product for each of those category from the dropdown and I would like to have this done thru VBA

Thank you!

I have attached the sheet, may be it can help you explain my problem better.

the idea is to create a Data validation - Drop down list in VBA . The list will have all the products corresponding to the category.

Please let me know if im not clear on the explanation

Thanks, but I am looking for the solution in VBA.

Thanks, could you please explain me how and what we are doing here ? - still learning

Yes thats true. If In case I share the excel, it may or may not work

Hello Marvin,

I requested for a VBA solution becuase the case I presented in this thread will be part of a VBA code im working.

So I cant have a Macro and a non VBA solution for this alone.

Thanks