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