Copy info in a range that always changes.
 

I have the following list

row 9 piece 1 12x12x12 $$$
row 10piece 2 12x24x12 $$$

Row 15 total material $$$

This list can have a various amounts of entrys so "total material" will not
always be Row 15 (piece 1 will always be row 9) and I would like to know if
there is a way to tell excel to Find what Row "total Material" is in and copy
Range ("9:"total Material" row)

Thanks in advance

Copy info in a range that always changes.
 

Have you tried using the vlookup function?


--
mcarrington
------------------------------------------------------------------------
mcarrington's Profile: http://www.excelforum.com/member.php...o&userid=21641
View this thread: http://www.excelforum.com/showthread...hreadid=500803