Dynamic drop down list

[david.paton]

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

 

[AccessBlaster]

This site has some useful information.

How To Create Dynamic Drop Down Lists In Excel

 

[Gasman]

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.?