On Sep 2, 12:44*pm, Ratedr wrote:
If you have a free second, please just help me by pointing towards the
right sheet,
I will do all of the work, Im not asking for you to do the actual
sheet for me, just
as someone with the knowledge you have, would like you to help me find
which one
of those sheets will be best suited for my issue

On Sep 2, 10:20*am, Ratedr wrote:



awesome..the only thing is this reads like a different language to me,
I will do all of the work, just asking for suggestions as to which one
of these you think would best solve my issue. *I will download that
one and fill in all of the info, etc

On Sep 2, 10:05*am, Don Guillett Excel MVP
wrote:

On Sep 2, 8:26*am, Ratedr wrote:

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?

http://www.contextures.com/excelfiles.html#DataVal-Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

Please learn to refer to excel files as file or workBOOKS. Sheets are
tabs within the workbook. Read her documentation and download several
to see which fits your needs. If you need custom work, post back.