Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating drop downs for part number configuration
I am looking to create a configure part number using information in a
spreadsheet. Static information will include the base part number, description, price and package. User can select a suffix that is linked to the package. For example: S1ZB80, Diode, .05, 1F. The user then could select 5000 - bulk, qty 50 5010 - magazine, qty 100 5020 - Ammo pack; qty 1000 5030 - Tape and Reel, qty 2500 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating drop downs for part number configuration
Try looking he
http://www.contextures.com/xlDataval02.html -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Peter" wrote: I am looking to create a configure part number using information in a spreadsheet. Static information will include the base part number, description, price and package. User can select a suffix that is linked to the package. For example: S1ZB80, Diode, .05, 1F. The user then could select 5000 - bulk, qty 50 5010 - magazine, qty 100 5020 - Ammo pack; qty 1000 5030 - Tape and Reel, qty 2500 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating drop downs for part number configuration
Luke,
Thanks for the help. I was able to use what I learned in the link to solve my issue. Peter "Luke M" wrote: Try looking he http://www.contextures.com/xlDataval02.html -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Peter" wrote: I am looking to create a configure part number using information in a spreadsheet. Static information will include the base part number, description, price and package. User can select a suffix that is linked to the package. For example: S1ZB80, Diode, .05, 1F. The user then could select 5000 - bulk, qty 50 5010 - magazine, qty 100 5020 - Ammo pack; qty 1000 5030 - Tape and Reel, qty 2500 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop downs | Excel Discussion (Misc queries) | |||
drop downs | Excel Discussion (Misc queries) | |||
drop downs | Excel Discussion (Misc queries) | |||
drop downs | Excel Discussion (Misc queries) | |||
Cross-referenced drop-down menu (nested drop-downs?) | Excel Worksheet Functions |