Macros : to copy the number down

[Kazdima]

Hello,
I have 100 GL accounts and each GL has the same list of projects, as example- six projects.
I need to copy each GL account down for each project.
Can you help to write a Macro to automate this process?

<colgroup><col style="mso-width-source:userset;mso-width-alt:3876;width:80pt" width="106"> <col style="mso-width-source:userset;mso-width-alt:4608;width:95pt" width="126"> </colgroup><tbody>
[TD="class: xl75"]

<colgroup><col style="mso-width-source:userset;mso-width-alt:3876;width:80pt" width="106"> <col style="mso-width-source:userset;mso-width-alt:4608;width:95pt" width="126"> </colgroup><tbody>
[TD="class: xl76, width: 106"]Column A[/TD]
[TD="class: xl76, width: 126"]Column B[/TD]

[TD="class: xl77"]GL Account[/TD]
[TD="class: xl77"]Projects[/TD]

[TD="class: xl76"]100[/TD]
[TD="class: xl78"]Abc[/TD]

[TD="class: xl78"] [/TD]
[TD="class: xl78"]Bcd[/TD]

[TD="class: xl78"] [/TD]
[TD="class: xl78"]Cde[/TD]

[TD="class: xl78"] [/TD]
[TD="class: xl78"]Def[/TD]

[TD="class: xl78"] [/TD]
[TD="class: xl78"]Fgh[/TD]

[TD="class: xl78"] [/TD]
[TD="class: xl78"]Ghi[/TD]

[TD="class: xl76"]200[/TD]
[TD="class: xl78"]Abc[/TD]

[TD="class: xl78"] [/TD]
[TD="class: xl78"]Bcd[/TD]

[TD="class: xl78"] [/TD]
[TD="class: xl78"]Cde[/TD]

[TD="class: xl78"] [/TD]
[TD="class: xl78"]Def[/TD]

[TD="class: xl78"] [/TD]
[TD="class: xl78"]Fgh[/TD]

[TD="class: xl78"] [/TD]
[TD="class: xl78"]Ghi[/TD]

[TD="class: xl76"]300[/TD]
[TD="class: xl78"]Abc[/TD]

[TD="class: xl78"] [/TD]
[TD="class: xl78"]Bcd[/TD]

[TD="class: xl78"] [/TD]
[TD="class: xl78"]Cde[/TD]

[TD="class: xl78"] [/TD]
[TD="class: xl78"]Def[/TD]

[TD="class: xl78"] [/TD]
[TD="class: xl78"]Fgh[/TD]

[TD="class: xl78"] [/TD]
[TD="class: xl78"]Ghi[/TD]

[TD="class: xl76"]400[/TD]
[TD="class: xl78"]Abc[/TD]

[TD="class: xl78"] [/TD]
[TD="class: xl78"]Bcd[/TD]

[TD="class: xl78"] [/TD]
[TD="class: xl78"]Cde[/TD]

[TD="class: xl78"] [/TD]
[TD="class: xl78"]Def[/TD]

[TD="class: xl78"] [/TD]
[TD="class: xl78"]Fgh[/TD]

[TD="class: xl78"] [/TD]
[TD="class: xl78"]Ghi[/TD]

</tbody>

[/TD]

[TD="class: xl76"][/TD]

[TD="class: xl76"][/TD]
[TD="class: xl76"][/TD]

[TD="class: xl76"][/TD]
[TD="class: xl76"][/TD]

[TD="class: xl76"][/TD]
[TD="class: xl76"]Thank you
[/TD]

[TD="class: xl76"][/TD]
[TD="class: xl76"][/TD]

[TD="class: xl76"][/TD]
[TD="class: xl76"][/TD]

[TD="class: xl76"][/TD]

[TD="class: xl76"][/TD]

[TD="class: xl76"][/TD]

[TD="class: xl76"][/TD]
[TD="class: xl76"][/TD]

[TD="class: xl76"][/TD]
[TD="class: xl76"][/TD]

[TD="class: xl76"][/TD]

[TD="class: xl76"][/TD]

[TD="class: xl76"][/TD]

[TD="class: xl76"] [/TD]
[TD="class: xl76"][/TD]

[TD="class: xl77, align: right"][/TD]
[TD="class: xl76"][/TD]

[TD="class: xl76"][/TD]
[TD="class: xl76"][/TD]

[TD="class: xl76"][/TD]
[TD="class: xl76"][/TD]

[TD="class: xl76"][/TD]
[TD="class: xl76"][/TD]

[TD="class: xl76"][/TD]
[TD="class: xl76"][/TD]

[TD="class: xl76"][/TD]
[TD="class: xl76"][/TD]

</tbody>

 

[Kazdima]

Do not know Mark858...may be I did smth wrong...

 

[MARK858]

Do not know Mark858...may be I did smth wrong...

Is your actual data laid out the same as post number 1 i.e. are there 5 spaces between every change of GL Account?

 

[Kazdima]

Thank you Mark858,
Peter resolved the problem.
Dan