Excel macro to create account statements

I have an Excel file where I enter the debts and payments of all my clients (64 clients) horizontally and I require a macro that extracts that information and generates individual account statements per client