sorting a list of customer invoices from columns into rows / customer

Hi All,

Cant quite get my little macro to work.

Basic premise is i have a table of customer records in the following format.

Customer1 | Invoice no. | Invoice class | Due Date | Amount
Customer1 | Invoice no. | Invoice class | Due Date | Amount
Customer1 | Invoice no. | Invoice class | Due Date | Amount
Customer2 | Invoice no. | Invoice class | Due Date | Amount
Customer2 | Invoice no. | Invoice class | Due Date | Amount
Customer3 | Invoice no. | Invoice class | Due Date | Amount

What i need to do is to sort these records so that i have 1 row for each customer which repeats the various fields accross the row instead of listing them on multiple rows.

e.g

Customer1 | Invoice no. | Invoice class | Due Date | Amount | Invoice no. | Invoice class | Due Date | Amount

Problem that i am having is remembering where the customer "changes"

see my attempt:

Please Login or Register  to view this content.

Any help would be greatly appreciated! - Still struggling with this one.