Drop Down List created from many tabs

[usrobinjo]

Hi:

I need to create a drop down list which is made up of the other sheets in the same document. For example the main sheet is named "Product Line Summary" and the rest of the sheets are the months of the year. On the Product Line Summary sheets, I want to be able populate it with the data from the sheet named "January" or "febrary",etc.

Any help you can provide would be awesome!

Thanks.

[dilipandey]

Hi usrobinjo,

You can do so by defining names with workbook scope... upload a sample workbook if you face any challenge. Thanks.

Regards,
DILIPandey
<click on below * if this helps>