My source data looks like the example below.


SKU# DIE# DIE TYPE DIE LOC
yhmia.2615.1.400 8122 E 123
yhmia.2615.1.400 8063 F 241
yhmia.2615.1.400 8019 F 181


--
joe1182
------------------------------------------------------------------------
joe1182's Profile: http://www.excelforum.com/member.php...o&userid=30977
View this thread: http://www.excelforum.com/showthread...hreadid=506490