Steve,

I am not sure if excel can perform this function. One thing I didnt
mention is that this sheet I am making will also get larger due to the
fact that as I select a product from the pull down and then enter in
all my time data for the different cycles, my next line down will be a
new product that I am entering for the next cycle. The cells where I
want the cycle times of the different products to appear will have to
have a formula that looks at the next product cell in-line before it
can put in the correct cycle times. If this isnt clear it will be ok.

Thanks again
Ed


--
changetires
------------------------------------------------------------------------
changetires's Profile: http://www.excelforum.com/member.php...o&userid=35414
View this thread: http://www.excelforum.com/showthread...hreadid=554236