See Debra's site for dependent DV lists

http://www.contextures.on.ca/xlDataVal02.html


Gord

On Mon, 17 Oct 2011 10:03:09 -0700 (PDT), LUIS ANGEL
wrote:

Hello guys,

I have a BIG list of part number and serial numbers, in the
thousands.

In one sheet a have a dropdown box that has all the part numbers. what
I would like to do is, have the sheet display all the serials of the
part number I choose from the dropdown box.

So if goe example I choose part number c123, in some point of the
sheet all the serials corresponding to c123 will show up.

Any ideas?