To whom it may concern,
I am in the process of creating an excel template, that will act as a
product database. I do not want to use access because most individuals are
not familiar with the program. The left hand column (column A) of my
worksheet lists general attributes of the product (the general
specifications). In columns B,C, and D, I list the specific specification of
each product. I am trying to standardize the work sheet so that it will be
easy for people to populate it and the information entered will always be
consistent. The specification for each product will be different, however
there is a limited number of differences that are possible. For example,

Column A the general specificatiion is a follows/Column B, Column C Specific
spec is as follows

Manufacturer: / BMW
/ Audi
Model: M3
S4
gear box: manual
automatic
etc...
etc... etc...

What I would like to do is make a list for column B and C where a regional
rep. can just choose which manufacturer, model, gear box, etc... for a
predetermined list. I have tried using the list function in excel 2003,
however each time that I try I am forced to have a colum label it turns out
looking like this

Manufacturer Manufacturer
Manufacturer
BMW
Audi
Model model
model
M3
S4
gear box gear box
gear box
manual
automatic

etc... etc.. etc..

In other words, I dont want to have a list label, I just want people to
select the model from the list, and that is the only thing that appears on
the list.
Thank you very much in advance.
Best Regards,
Laurent