That is a possibility but would require a complete revamp of a
production schedule. The schedule currently has about 200 SKU's on it
on a daily basis. To keep the size of the schedule down in page
length(currently 4) we use a 7 font and put all of the SKU's for the
appropriate machine in one cell.

Because some days a certain line might have 1 or even 20 SKU's in its
box having columns for each individual SKU may not be possible. Having
it all in one cell means you would just adjust the cell height and
width for a quick fix to more or less SKU's.

I had just assumed this would be an easy formula for the excel masters
here but it looks like it may be very difficult.


--
Brad1982
------------------------------------------------------------------------
Brad1982's Profile: http://www.excelforum.com/member.php...o&userid=15690
View this thread: http://www.excelforum.com/showthread...hreadid=501093