Hello all,

I am working with a worksheet that contains thousands of different part numbers, some of them containing different configurations.

Ex. Part Number: 1-1500-10,11,15 (This is the format these parts numbers are currently in).

This means that there are three different parts in that one cell, parts 1-1500-10, 1-1500-11 and 1-1500-15.

What I seek to do is to find which parts contain "," (which means that the base part has multiple configurations), and split this base part to let each configuration have their own row (to insert new rows beneath), and copy the information from the original contained in adjacent columns.

Ex. The part number 1-1500-10, 11, 15 would go to:
1-1500-10 ...... Same information from base part.......
1-1500-11 ...... Same information from base part.......
1-1500-15 ...... Same information from base part.......

I have already determined which ones have multiple configurations with a simple ISNUMBER, but there are over 1000 different base parts, each with several different configurations.

If anyone has some good ideas for VBA or anything easy to do this, it would save me quite a bit of time.

Sincerely,
MR