I want to allow a excel user to save a cell value to the bottom of a drop down list on another worksheet. This would provide the user the ability to re-use the unique cell value as needed. It would have to add to the bottom of an already running list.

Any ideas?

(PS - I don't have a clue how to write macros but oddly enough can understand those that have been written. HHHMMMM