creating a dropdown dynamically in multiple rows & assiging values to it from database

I am opening the Excel sheet Template from vb.net with few records from vb.net ie Exporting data from the application
when the Excel template gets opened with the data the user needs to just eneter Qty in each row & select a data from the dropdown which is created in each line

so i think i dont need the reference of dropdown in vb.net once its exported,
if i am able to populated the dropdown in vba as all the dropdown will have the same data from datatable

let me know whts the best


populating the dropdown from vb.net code & then exporting wuld take time , i suppose