Column D has the drop down selections.
Ideally, entering data into column A should trigger column D to populate, but I believe the way the code operates anytime a change is made to the worksheet column D is populated if Column B is empty.
I had thought about using a form for data entry and tested one, but the data going into column B (Vendors) can be highly repetitive and found the auto complete capabilities (not sure if I'm calling this the right name) was easier and faster than using a form. The form wasn't created in VB though , but through the Data menu and selecting Form.
I don't even think I know enough to say I'm barely conversant in VB, but would like to be. Which brings up a question; with so many references on the net and books available, where and how does one go about starting to learn and understand VB?
Thank you again.