assuming you are not looking for something quite as simple as
higlighting the row below where you want the space and clicking on
Insert Row, you could maybe write an if statement that would compare
above and below and take the next row if different but what I would do,
for a quick result, is one of the following -

Either
use the data subtotals menu options which would not only break up your
data but also subtotal it (or average, or count etc)

Or
use the Data, Filter, Advanced filter options to do a unique extract of
the part numbers - apend this to the bottom of the list and then sort by
the whole part number column - the appended unique records create a
blank line for each part number - to make sure they always come at the
end put another helper column in (before you sort) for these appended
records and use that as the secondary sort.. If you want the line to
be completely blank then copy the part number into a helper column,
apend the unique records to the bottom, sort the column (remembering to
include all the other columns) and then delete the helper column.

R


--
Ruthki
------------------------------------------------------------------------
Ruthki's Profile: http://www.excelforum.com/member.php...o&userid=24503
View this thread: http://www.excelforum.com/showthread...hreadid=394215