You're welcome!

--
Biff
Microsoft Excel MVP


"William" wrote in message
...
Thanks to you both!
--
William


"T. Valko" wrote:

Use a dynamic range to define the source for the drop down.

Assume the source list is currently in A1:A5

Use this formula as the source for the drop down:

=A1:INDEX(A1:A10,COUNTA(A1:A10))

This allows you to add new items up to cell A10. Adjust this to suit your
needs.


--
Biff
Microsoft Excel MVP


"William" wrote in message
...
Once a drop down list (created from a named list) has been created and
the
file saved, is it possible to add an item to the drop down list, and if
so
how? I type a new item at the bottom of the named list, but can't
figure
out
how to ask excel to extend the drop down list by the additional item.

Thanks.
--
William