I need to set up a very simple database in Excel for a coworker; Access would be too complicated for her to use. I apologize if I don't know the correct terminology, but here is what I need:
--need to set up an Excel spreadsheet that will allow us to choose from a customer dropdown menu on each row. The selection will need to fill in the customer number, name, and contact info., which could be in one cell or spread over multiple cells.  If this type of thing has a specific name, please inform me.
--we would also need to keep a running list of active customers to choose from that can be edited to add new customers and delete old ones.
Thanks for your help.