Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
creating lists
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
creating lists | Excel Discussion (Misc queries) | |||
Creating drop down lists | Excel Worksheet Functions | |||
Creating Drop Down lists | Excel Worksheet Functions | |||
creating lists | New Users to Excel | |||
Creating fixture lists | Excel Worksheet Functions |