jlclyde explained :
I want to do this in excel because I do not want to have to go back
out of excel to calculate how many I can get out a parent size stock.

Jay,
Yeah, I can understand that. The software I use (SolidWorks) supports
'Design Tables' which are Excel spreadsheets, and so this is
integrated. I'll see what I can find out about how this is done...

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc