software

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: www.excelforum.com/member.php...nfoamp;userid=300
View this thread: www.excelforum.com/showthread...hreadid=496687Hi Jim. The attached site about Dynamic Drop Down lists may help.
www.xldynamic.com/source/xld.Dropdowns.html
--
Sincerely, Michael Colvinquot;Jim Johnsonquot; wrote:

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


How about this:
In an out of the way of your workbook, create a table with all your
part number in one row and under each part number fill down your
individual list.
Next select a cell to put your part numbers list in, say A1, goto
Data/Validation select quot;listquot; in the Allow menu and in the formula box
below type = and the location of your part numbers range. Next put this
formula in another cell and copy down:
=HLOOKUP($A$1,your_table,ROW(2:2),0)
you could also give your table a name for ease of use...say table1 and
then use:
=HLOOKUP($A$1,table1,ROW(2:2),0)

HTH
JG--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: www.excelforum.com/member.php...foamp;userid=6261
View this thread: www.excelforum.com/showthread...hreadid=496687