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.