I am trying to design a marco that will aid in my weekly payroll. I have a workbook (worksheet for each month) where I list the sales, sales rep, amount reps get paid, date funding received, date paid, along with a few other odds and ends. What I want to do is run a macro that will gather the names of the sales, amount the rep is to be paid for each sale, list the sales, amounts the rep will be paid, and then total them at the bottom. I want the report to look something like this:

Sales Rep Sales Rep
Customers name $$$$$ Customers name $$$$$
Customers name $$$$$ Customers name $$$$$
Total $$$$$ Total $$$$$

A column for each rep so that not only can I verify the amounts but I can cut off each reps list to include in their checks. Can this be done and where do I begin????