I export our inventory report into excel. In column A we have out serial
numbers and column B is our part numbers and column C is our quantity. The
part number is only listed once in column B then in the rows below the part
number in column A is the serial numbers for the part. Is there a vb program
that could automatically highlight the serial numbers for a part number and
group them together so that I can then manipulate my sheet with out loosing
the serial numbers that go along with the part numbers?