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