David, thanks for the tip but unfortunately it's not exactly what i wa
looking for. I thought i had been specific enough and i did reply t
tom prior to your posting. Maybe this will help clarify:

_Column_1_
Row 1 - Name
Row 2 - Address 1
Row 3 - Address 2
Row 4 - City, State Zip

_Column_2_
Row 1 - # pieces

_Column_3_
Row 1 - type of transaction (just one letter)

I am trying to sort in order to help route our trucks but keep th
groupings together

--
acarri
-----------------------------------------------------------------------
acarril's Profile: http://www.excelforum.com/member.php...fo&userid=1002
View this thread: http://www.excelforum.com/showthread.php?threadid=27741