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

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

Nigel, perhaps this explanation will help.

A workbook is used for one month and is then saved under another name
for archive purposes. All data in the original workbook is then deleted
leaving a blank workbook. This blank workbook is then used for the next
month (which is now the current month). I have already automated the
archiving and data deletion via a macro.

During the month when the workbook is required to record a business
activity, names of other businesses need to be entered in column C.
These names are one of three types: new names; names that have been
already entered this month; or names entered in previous months.

What I need is a system whereby names previously entered, either this
month or earlier, will automatically fill the focus cell as the user
starts typing. Obviously, if it is a new name the auto fill in will not
work but that name needs to be added to the list.

Orf

Nigel wrote:

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

My situation:

A workbook is used for one month and is then saved under another name
for archive purposes. All data in the original workbook is then deleted
leaving a blank workbook. This blank workbook is then used for the next
month (which is now the current month). I have already automated the
archiving and data deletion via a macro.

During the month when the workbook is required to record a business
activity, names of other businesses need to be entered in column C.
These names are one of three types: new names; names that have been
already entered this month; or names entered in previous months.

What I need is a system whereby names previously entered, either this
month or earlier, will automatically fill the focus cell as the user
starts typing. Obviously, if it is a new name the auto fill in will not
work but that name needs to be added to the list.

As I see it, a drop down list would not be acceptable because the list
of names could be in the order of 200. On the worksheet, column "I" is
not being used and a list could be put in there manually. So what would
be required is a macro that accesses the list in column "I" so that as a
name is being typed in column "C" it is checked against the list in "I".
Where the characters match, the the remainder of the word is added to
the letters already typed in "C". Is this possible?

An added feature would be if the characters being typed in "C" do not
have a match in "I" then that word is added to "I" for future
comparison. This addition should occur when the focus leaves the "C" cell..

Can anyone help.

Orf