Excel 2013 - Data Validation HELP

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

ozzrek

Thread Starter
Joined
Mar 23, 2016
Messages
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!
 

Attachments

Joined
Jan 15, 2004
Messages
770
In my opinion the nest way to create validation lists is to create a new sheet I usually call it ValidationSheet, create all your lists in this sheet so for example if you wanted a list of vendors you can enter them in column A

Say for example you had a column heading called Vendor List in A1 and a list of Vendors from A2 to A7, you can then highlight A2 to A7 and give that range a name such as 'VendorList' then when you create a validation list, you can say '=VendorList'

see the attached workbook this will show you what I mean

if you need help with what you currently have, please upload the file (remove sensitive information) and we can try and help.
 

Attachments

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

No members online now.
Top