Create dropdowns in excel

Hi,

I have a case where I am supposed to create an excel sheet, comprising of dropdowns in it, which takes the data from another workbook.
How can I proceed forward with it.

Regards,
Rhitam Deb

Hi @Rhitam_Deb,

Try to do this with VBA

Thanks,
Aisling

1 Like

Hi @Rhitam_Deb

  1. u can use VBA code from background
    2.otherwise click-> data menu in excel file and click-> Data Validation->setting->list->select the source and click ok