Dynamic drop down list (1 Viewer)

david.paton

Registered User.
Local time
Today, 04:52
Joined
Jun 26, 2013
Messages
338
I have a tab that quotes are generated on. A list of providers are stored in another tab.

I need a dynamic drop down list in the quote tab so that more providers can be added to the list. The list is rather long so it is sorted alphabetically to help find providers. How do I add a drop down list that is dynamic and increases as more providers are added?

I can't upload the spreadsheet for privacy reasons.

Thanks,
Dave
 

Gasman

Enthusiastic Amateur
Local time
Today, 11:52
Joined
Sep 21, 2011
Messages
14,038
Also if you put them an a table, that automatically adjusts to new entries.

I did notice that when he was showing the code and the ranges, that only the last variable was defined as a range.?
 
Last edited:

Users who are viewing this thread

Top Bottom