TechSpot

Excel 2013 - Data Validation

By Ozzrek
Mar 23, 2016
Post New Reply
  1. 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!
     

    Attached Files:

    Last edited by a moderator: Mar 23, 2016
  2. jobeard

    jobeard TS Ambassador Posts: 9,322   +622

    Cells Q17 thru Q251 are being referenced, if either does not exist, you will have problems
     

Similar Topics

Add New Comment

You need to be a member to leave a comment. Join thousands of tech enthusiasts and participate.
TechSpot Account You may also...