Vba not working afetr adjusting rows and columns

Hi

I am kindly asking for help on VBA code. The code was working well but when I adjusted rows and columns of my worksheets its no longer working. Please not that there are two sales data in one sheet: one is for ZW$ (Column G to Y) and one for US$ (Column AH to AZ). Customer statements are two in one sheet, one for ZW$ and the other one for US$ and the same applies with opening balances.

Please find the attached worksheet including VBA code.


Thank you.

Regards,

Sunboy