I have gropus of data that are imported.

Heading
Phone #
Part Name & #
etc
etc

Heading
Phone #
Part Name & #
etc
etc

Heading
Phone #
Part Name & #
etc
etc

Pattern continues for over 100 pages.
Now I want the cell "Part Name & #" to be selected and moved up to an empty
cell to the right of the cell "Heading". What from a code standpoint would
that look like in Visual Basic within a macro? I want ALL of the groupings
done in this way. They are all imported in the same patterns, so if there is
some way to select all cells with "Part Name & #" have them move up two
spaces and over 5 or 6 cells then paste, that would work. Make sense???

THANKS!!!!