Hi all
It's a bit tricky to explain so I've attached a couple of docs. The attachment called template is a simple example where I've got names of staff at the top and the volume of hours they work. Underneath is the work that needs to be done and split up between the people pro-rota to the number of hours they work. That's the easy bit which I've done, but I'm wondering if there's anything excel can do to read how many pieces of work each person should have and put their name against that specific volume of pieces of work. The attachment called idealtemplate is what it would look like in my mind but I've just manually typed the names in this one, rather than having the functionality to automatically do it.
Any help would be greatly appreciated.
Thanks
Bookmarks