Inserting rows through excel macro

Closed
Meg - May 27, 2010 at 02:44 PM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- May 28, 2010 at 04:24 AM
Hello,

I have 29 rows of product numbers composed of 6 different products in an Excel spreadsheet. I need a macro formula that will insert five rows after the product number changes. So basically it would look like this

555666
555666
555666



555777
555777




555888

and so on and so forth until all the product numbers are seperated.

Thanks for the help!


1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
May 28, 2010 at 04:24 AM
is data sorted on name already ?

if not, then can data be sorted
0