Presumably you are manually deleting the entries after you have archived the
current month if so then
don't delete them and sort them using data-sort options. But I'm not sure
this is what you are really asking?

Putting them into a drop down list is a simple matter and requires setting
up a listbox, however I suspect you are trying to use this as a data entry
feature so in this cae you might consider using the Data-Validation option,
however adding a non-existent entry would then require some work to get this
into the list. There are many options depending on what you are trying to
do.

Could you be more precise as to what you really want to do and the way you
visualise it working.

Cheers
Nigel

"Orf Bartrop" wrote in message
...
My workbook has a column in which names of businesses will be entered as
correspondence is sent to those businesses. At the end of each month the
workbook will be saved for archiving and then all entered data wiped
ready to start the new month.

Is there a way of retaining those names and storing them in alphabetical
order so that they will automatically show in the new monthly workbook?
This facility would appear to be an extension of the "Automatically fill
in repeat entries in a column" feature. Alternatively, would it be
possible to have the list displayed as a drop down list so that the
required entry could be selected?

Orf Bartrop