Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 349
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,722
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 349
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Drop downs How do add Drop down list Excel Discussion (Misc queries) 2 December 19th 08 03:45 PM
drop downs Onecrazyeye Excel Discussion (Misc queries) 1 August 5th 08 09:09 AM
drop downs Mick Excel Discussion (Misc queries) 2 May 11th 08 05:16 PM
drop downs nanpenguin Excel Discussion (Misc queries) 2 February 3rd 06 11:27 AM
Cross-referenced drop-down menu (nested drop-downs?) creativeops Excel Worksheet Functions 4 November 22nd 05 05:41 PM


All times are GMT +1. The time now is 12:36 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"