List Box, Combo Box, Autocomplete, Alt + DwnArrow....None meet the requirements

Hello,

In the attached excel spread sheet (Bid.xlsm) (a bid form). I would like for it to remember every entry ever put into the "Attention" cell and the "Company" cell. The idea being that the user could do the 'Alt Down Arrow' thing and get a list of previous entries to choose from.

This would be like the autocomplete function except instead of being based on other column entries it would be based on previous cell entries.

We send bids for multiple different projects to the same Company on the same day to different people's Attention in different departments. We do this often so being able to type the first few letters of somebody's name and few letters of the company name would save much time.

Thank you,
Mark

You might be able to do something like this, but amended slightly to save previous entries in the Data Validation list...

http://www.youtube.com/watch?v=vOOuSe_s6pQ