Hi All, I want to create a dropdown in one excel workbook and the source date is another workbook. Whenever we add more data in source file , need to be reflected in drop-down . I want to create an excel macro for this. Can you please guide? Thanks Rajeev

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Create a Dropdown in one excel workbook and the data source is another workbook - Macro Required

Thread starter rajeevg
Start date May 13, 2015
Tags

excel dropdown macro - run

rajeevg

New Member

May 13, 2015

Hi All,

I want to create a dropdown in one excel workbook and the source date is another workbook. Whenever we add more data <gs id="b70b3f28-fa4a-4fc1-a025-beba340ed036" ginger_software_uiphraseguid="c9cce16f-b9fc-4119-aca8-7fb8f30199dd" class="GINGER_SOFTWARE_mark">in</gs> <gs id="824d5fbb-199a-44a2-b04f-790d32a7a6f9" ginger_software_uiphraseguid="c9cce16f-b9fc-4119-aca8-7fb8f30199dd" class="GINGER_SOFTWARE_mark">source file</gs>, need to be reflected in <gs id="b2551c42-9ac9-4a31-9d5e-fbb52f379914" ginger_software_uiphraseguid="c9cce16f-b9fc-4119-aca8-7fb8f30199dd" class="GINGER_SOFTWARE_mark">drop-down</gs>.

I want to create an excel macro for this. Can you please guide?

Thanks
Rajeev