Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
dropdown menu ? other ideas?
My company makes tubes. The tubes have different inside diameters,
and wall thicknesses. All of these tubes, start from 1 size tube, then they get drawn down (extruded) into different sizes. For example, if I needed a tube that was .250 inch inside, and .050 wall thickness, I have to go through 5 steps from the original part. To get a tube .125 inch ID and a .050 wall thicknesses, I have to go through 7 steps from the original part. NOW..I can also get from the first tube I mentioned, to the second in 2 steps. I have 84 total tubes combinations when it comes to the final part. They can all come from the original 1 size, or I can get from any size larger tube to any size smaller tube. I want to write a spreadsheet where someone can select the tube they have now, and then the tube they NEED, and it will list the steps needed to get to that point. What is the best way to go about that? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
select From dropdown and return another dropdown menu | Excel Discussion (Misc queries) | |||
Ideas for a menu | Excel Programming | |||
filter dropdown menu so 2nd drop menu is customized | Excel Worksheet Functions | |||
Create Dropdown menu without using the Validation on the Data Menu | Excel Worksheet Functions | |||
dropdown menu or Jump menu | Excel Discussion (Misc queries) |