grouping rows

[bduncan]

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?

 

[marcus]

If the part number appears only once in col B, then are the cells
beneath it blank until the next instance of a part number? I am going
to assume this is the case. You fill the blank rows inbetween part
numbers with the correct part number by;

Highlight Column B
Edit – Goto –Special
Choose Blanks, then OK.

Now all the blank cells in the column are highlighted. Press ‘=’ hold
the Control key and press ENTER.

This will ensure your part numbers are in the corresponding row to
your serial numbers. You can then manipulate the serial numbers as
the part number will be in the corresponding column.

Hope this helps.

Marcus

 

[bduncan]

Thanks for the reply. I'm using excel 2007 and when I highlight column B and
select go to blank it only picks one cell. Also when I highlight the blank
cells under a part number and press the Alt-enter-= together nothing happens.
Is there a setting that I need to change or am I doing something wrong.

 

[bduncan]

Thank you for the macro. It wasn't what I thought I was looking for. I was
looking for a way to group the part number with the serial numbers so that
when I sorted our part numbers the serial number would stay with the part
number. I thought grouping would do this but it appears I was mistaken on
that.