Hi, Please see the attached pic. In the workbook I am working on in the pic there are 3 pages page 1. is what looks like the main document that is worked in and it has a drop down menu that I would like to add vendors to a preexisting list (but I can not figure out how) page 2. is a list of venders mot NOT all of which are in the drop down menu already (if I edit the list the changes do not effect the corresponding vendor that are already listed in the dropdown menu on page1) page 3. named "sheet 1" seems to be blank and have no function ** in the picture you can see that I highlighted the "VENDOR:" drop-down and right bellow that I am showing the data validation for that drop-down. I would really like to be able to edit this drop-down list. Can someone please point me in the right direct? Let me know if you need any further information! Thanks a million!