dropdown menu ? other ideas?

[Ratedr]

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?

 

[Don Guillett Excel MVP]

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?

See ans in other post. Pls do not multi post