Limit drop down items based on another cell
 

I have a large list of customers and addresses. Some customers have several ship to addresses represented by a sequence number. When I type in a customer name, it automatically generates in the "bill-to". I'd like to then have a drop down that only lists that customer's sequence numbers in order to select a "ship-to". The data is as follows:

Cust......Seq
1........1
1........2
1........3
1........4
2........1
2........2
3........1

So, for example, when I select customer 1, I would like a drop down that contains seq 1-4.

Thanks for any help!

Brett

Limit drop down items based on another cell
 

Hi
See Debra Dalgleish's site, you may find what your looking for.
Create Data Validation dependant on other
http://www.contextures.com/xlDataVal13.html
http://www.contextures.com/xlDataVal02.html
http://www.contextures.on.ca/xlDataVal03.html

Thanks a lot for the resource. I got what I was looking for!

BD

Limit drop down items based on another cell
 

On Friday, April 18, 2014 1:19:01 PM UTC-4, BDAvs wrote:
Thanks a lot for the resource. I got what I was looking for!

You're welcome.
Thanks for the feedback