adding sheets and segregating data based on their type.

[boddulus]

Hi all, good morning, good afternoon,good evening to all, can some one please help me with V.B.A code. i am trying to frame a loop but not able to do it .

the macro should add two more sheets with names as first sheet : Bonds and second sheet name : Equity to report1 sheet.

the sheets should be added before report1 sheet.

the securities with type in L column should go to equity sheet and with type as bond should go to bonds sheet.

the headers in 1st row of both equity and bonds sheets will be same as report1 sheet.

so the first security with equity in L column will come in 2nd row on equity sheet.(Bonds also same.)

once all the securities are copied in there sheets the macro should create 2 blank columns in front of column D.

i have attached the sample sheet for your reference......

Thanks in advance.......

[stnkynts]

Please Login or Register  to view this content.

[boddulus]

thanks for your effort ... everything was perfect but macro should add two blanks columns before column D in both equity and bonds sheets ........ thanks for your effort once again.

[stnkynts]

Woops sorry about that. Try this:

Please Login or Register  to view this content.

[boddulus]

Thank you very much it helped me a lot.......