Return worksheet name where data is found on worksheet
Posted on 2013-11-26
I used Excel 2010 to figure the payroll commission that we pay our salespeople.
I have an individual worksheet for each person that totals in the same manner for everyone.
At the end, I have a page that totals all of the individual totals.
We use a "draw system" for paying our employees, which means that if they don't make a certain amount for this payroll period, we still pay them a base amount, but then they owe us back the difference on their next pay.
So, on each individual worksheet, there is a calculation for what the salespersons draw balance is, and like explained above, there is a total for this cell on the "totals" page.
I would like it to list somewhere on the totals page, which worksheets (or salespeople) have a draw balance of greater than $0.00.
For an (small) example:
Salesperson (worksheet) A $0.00
Salesperson (worksheet) B $ 5.00
Salesperson (worksheet) C $20.00
Totals worksheet draw balance = $25.00
On the totals page I would like to see:
Salespersons (worksheets) that have a draw balance of greater than $0.00
B $ 5.00