Design a macro for my project

[james98773]

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????

[rylo]

Hi

Sounds doable. How about setting up a before and after example sheet, showing the actual formats, but using non real data so we can see what to work with.


rylo

[james98773]

Here is a basic example. I have selected all the ones that are to be paid on 1/11/08.

[rylo]

Hi

Have a look at the attached file and see how it goes.

Please Login or Register  to view this content.

rylo

[james98773]

That works great, now all I have to do is put it to work. If I have any problems I know where to go. Thanks for the help.