Hi Jim. The attached site about Dynamic Drop Down lists may help.
http://www.xldynamic.com/source/xld.Dropdowns.html
--
Sincerely, Michael Colvin


"Jim Johnson" wrote:

>
> I am trying to build a spreadsheet where I can insert the parts list for
> various assemblies based a single part number that represents that
> assembly. I would like to do this using a drop down pick list if
> possible. I do not know VB(probably should though) so can anyone offer
> some help for this.
>
>
> --
> Jim Johnson
> ------------------------------------------------------------------------
> Jim Johnson's Profile: http://www.excelforum.com/member.php...nfo&userid=300
> View this thread: http://www.excelforum.com/showthread...hreadid=496687
>
>