Hey Excel wizards,
I’m here to ask on how to make a table for my work team that I can’t seem to figure out and it’s been bugging me for days.
We have a sales team of 40, and some of us want a daily target tracker. I’m looking to make a table based off each working day quarter where you can set the start and end date range, and it can average a $ target to a daily average that will roll over each day until the final day where it has your final target. I also want it to be able to input your current standings, and show a difference between the average and yourself. Each person’s target is different so I want anyone to be able to change the total $ amount and have it summarise per day.
Does anyone have any suggestions or recommendations as to what I can do?
Thankyou!
I’m here to ask on how to make a table for my work team that I can’t seem to figure out and it’s been bugging me for days.
We have a sales team of 40, and some of us want a daily target tracker. I’m looking to make a table based off each working day quarter where you can set the start and end date range, and it can average a $ target to a daily average that will roll over each day until the final day where it has your final target. I also want it to be able to input your current standings, and show a difference between the average and yourself. Each person’s target is different so I want anyone to be able to change the total $ amount and have it summarise per day.
Does anyone have any suggestions or recommendations as to what I can do?
Thankyou!
