kmyers1970
New Member
- Joined
- Aug 14, 2017
- Messages
- 4
I am trying to figure out a way to create a sheet for calculating bonus allocations from a sheet of data used to allocate payroll. Here is what the payroll sheet looks like:
<strike></strike>And the formulas I need would produce a list of employee ids and their entity allocation like this:
I am not limited to using formulas as I think I need a VBA macro to accomplish this. Any help would be greatly appreciated.
<strike></strike>EDIT:
I already messed up allocation screenshot - cell C2 and C3 should read 8% and 9%.

<strike></strike>And the formulas I need would produce a list of employee ids and their entity allocation like this:

I am not limited to using formulas as I think I need a VBA macro to accomplish this. Any help would be greatly appreciated.
<strike></strike>EDIT:
I already messed up allocation screenshot - cell C2 and C3 should read 8% and 9%.
Last edited by a moderator: