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:
Any help would be greatly appreciated! - Still struggling with this one.
Bookmarks