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?

Column A Column B GL Account Projects 100 Abc Bcd Cde Def Fgh Ghi 200 Abc Bcd Cde Def Fgh Ghi 300 Abc Bcd Cde Def Fgh Ghi 400 Abc Bcd Cde Def Fgh Ghi <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> </tbody>
	Thank you

<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>
</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