View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre Ron Coderre is offline
external usenet poster
 
Posts: 2,118
Default how do i set up a drop down list of materials?

Look into Data Validation at Debra Dalgleish's website:
http://www.contextures.com/xlDataVal01.html

You might also need Dependent Lists (also at her website):
http://www.contextures.com/xlDataVal02.html

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Kerky!" wrote:

I am working on a Bill of Materials and would like to create a drop-down list
for each category/ material type.
eg;
Material = repeater (drop down list of repeaters to select from)
=antenna (drop down list of antennas to select from)

Can anyone help me? the online help wasn't that useful as I'm not used to
running macros or doing add-ins.

Thank you,
M