shanka2020
New Member
- Joined
- Jan 4, 2016
- Messages
- 1
Hi there Excel Wizzes, I hope you can help. I'm trying to keep track of my sales team budget versus sales on a weekly basis by dividing their monthly budget into 4 weeks and then tracking their weekly sales against this. I would like to provide them at the start of the month their weekly targets (eg. Budget $1000 so Wk 1 $250, Wk 2 $250 etc) and then as they pull in sales I can add them to a total and the remaining weeks are then recalculated to reflect the balance remaining. I have created a spreadsheet already with some of this info on it if that makes it easier for you guys to work off, just ask and I will post it.
Thanks in Advance to you all
Thanks in Advance to you all