Repeating rows on specific creteria

[srinivasan1965]

Hi
I really thank you very much for your suppourt
I need one help from you.
We get ledger in excel as per the sheet "Raw Data".
We get ledger like this exceeding more than 10000 rows.
please refer the sheet " coding required"
I need vba coding inserting colum and repeat the columb( Account Head) to colum A until it finds word" Total" in colum B
So that i can do pivot or summary for my analysis purpose.
Please help me since I am 52 years old so that i can complete job quicly
Thanks

[alansidman]

Please Login or Register  to view this content.

[Mumps1]

Try:

Please Login or Register  to view this content.

[jindon]

Please Login or Register  to view this content.

[srinivasan1965]

Dear All
It works fine. Thanks a lot
I have tried all of your your coding It works fime
Only one thing it does not do for B2 cell " Fine computer systems" It does no
t get repeated.
Probably I have not mentioned my request well.
Thanks & Regards

[jindon]

Because of your bad representation of the result in your workbook.

Please Login or Register  to view this content.

[srinivasan1965]

Hi Jindon,
Thanks a lot
It works fine for all rows now.
I really thank you all from bottom of my heart
Regards
N.Srinivasan