My task is to track commissions for a small agency. I have created a
workbook that includes a worksheet for each provider which lists the
customer, amount paid, whether or not it is a renewal and which agent is due
the commission. I then have worksheets for each agent where I have copied
the rows that apply to the agent from each of the provider sheets. Using if,
then logic I get a total of first year and a total of renewal commissions.
For some of our more productive agents the formula can't be big enough. At
my beginner level I was proud of what I had created, but looking at the
groups I know I can do better. What do I need to study? arrays macros loops
I might be in over my head. Anybody have a suggestion?