Add X number of rows based on value of cell

[bqab]

Hi

I want to insert C rows of each ID from column A. The number of rows I want inserted differ for each ID.

Sample workbook is attached.

Cheers,

[scott.s.fower]

Please Login or Register  to view this content.

[bqab]

It adds one too many rows, but I can just dial the number down one.

Thanks a bunch I'll see if it works on the larger data set.

[AB33]

On your sample, you have one more rows than the numbers on the column C.