I have a worksheet with a drop down of active projects in one of its columns.
The data on what projects are active comes from a SQL server database. To
start the process I defined a range that includes all the imported project
data, created the drop down and copied it to the appropriate number of rows
in the Projects column.

I have the query dropping the data to an area outside of the normal viewing
area. Over time, the project mix will change, so I need to update the
dropdowns(s). I have no problem refreshing the data from the query, but seem
unable to get the range to resize in the dropdowns following the example in
the online documentation. I intentionally used a named range assuming that
would eliminate the need to go row by row to update the dropdowns.

This leads me to two questions:
1. Are the data in the dropdowns static once populated, or should resizing
the range effect the dropdowns?
2. Am I going about this whole thing correctly?

Thanks in advance for any assistance or insights.

John