Insert Rows based on cell value

[jholbrook]

HI,

Im looking for a macro to insert cells based on values in certain cells. I have a list of unit #'s that contains an A, B, C, D or E in the text string and I'm looking for a macro to insert a certain number of rows based on what is in that cell.

For example in cell A6 the value is 3120-101-A

The amount of rows entered below A6 would need to be:
A=2
B=3
C=4
D=5
E=6

I would need this to go searching column A until no more data is found.

Thanks,

Jonathan
__________________________________________________________________

Mod edit : thread moved to appropriate forum !​

 

[YasserKhalil]

Hello Jonathan
I think it is better to upload a sample of your workbook with the desired output

 

[jholbrook]

Attached is the example. I need to add a certain number of rows under column A (bldg-unit) based on what letter is at the end of the text string.

 

[NARAYANK991]

Hi ,

See if this is OK. Run the macro named InsertRows.

Narayan

 

[jholbrook]

Thanks Narayank! Almost perfect, I need one more row added per letter.

A=2 rows below unit #
B=3 rows below unit #
C=4 rows below unit #
D=5 rows below unit #

 

[NARAYANK991]

Hi ,

Sorry , my mistake. See the attached file.

Narayan