Excel VBA posting General Journal to General Ledger

Hello Guys,

In the attached workbook, I need to take the sheet "G.JOURNAL" and post it become format of "G.LEDGER" with a macro.

I don't know how I can do this since the number of lines vary for each account number (increased or decreased)

Please help with formatting all of "G.JOURNAL" into "G.LEDGER" with a macro (just like the sample at sheet "G.LEDGER"). If I do this manually this will take lots of time.

Please help me with this guys, I've been googling but found nothing about this problem. Thanks

Can anyone help me to solve this problem please, or is it too complicated to write a macro