Populate Drop Down List
 

I am wondering if it is possible to place a formula in a column that will
keep track of items entered and save them as a drop down list.

I have a spreadsheet tracking project costs from various vendors. I do not
know which vendors will be used for a particular project, so I am not able to
create a drop down list.

I would however, want if vendor XYZ Coporation was typed, the this vendor
would now appear in a list to be selected at a later time.

Assuming your list was self adjusting from a defined name you could use a
worksheet_change event to place the name at the end of the list if not
duplicated in the list and then sort...

--
Don Guillett
SalesAid Software

"Wuttie" wrote in message
...
I am wondering if it is possible to place a formula in a column that will
keep track of items entered and save them as a drop down list.

I have a spreadsheet tracking project costs from various vendors. I do
not
know which vendors will be used for a particular project, so I am not able
to
create a drop down list.

I would however, want if vendor XYZ Coporation was typed, the this vendor
would now appear in a list to be selected at a later time.