PaulPlumridge
New Member
- Joined
- Jan 10, 2019
- Messages
- 11
Good Morning
I hope you are all well. I'm looking for some help on on designing commission sheets for my sales team.
We have a master file for 2019 that lists every commission our company earns in roughly this format
Date / Month / Salesman / Invoice No / Customer / Comm £
Each day new deals get added as new lines on the bottom of the master data.
The sales guys have their own sheets for each month with the same headers as above - what i am looking is a way for their individual sheets to automatically update the data from the master file.
Is this even possible? if so what would the formula structure look like
Thank you for your help
I hope you are all well. I'm looking for some help on on designing commission sheets for my sales team.
We have a master file for 2019 that lists every commission our company earns in roughly this format
Date / Month / Salesman / Invoice No / Customer / Comm £
Each day new deals get added as new lines on the bottom of the master data.
The sales guys have their own sheets for each month with the same headers as above - what i am looking is a way for their individual sheets to automatically update the data from the master file.
Is this even possible? if so what would the formula structure look like
Thank you for your help