Hi all, Im new here so I really hope you can help.

At present, we have to work cases from 8 system generated lists.
We have to spread the cases amongst a different number of users and then work out how many cases each user should be allocated from each of the worklists.

The worklists are just 2 columns, customer surname and customer number

What I would really love to be able to do, so save us quite a bit of time is:

Have a workbook with an front page whereby the names of the users in that day is entered along with the hours they are allocated to work these particular cases.

Then enter each of the worklists in to a seperate worksheet (eg labelled Worklist 1, worklist 2 etc)

Then for these cases to be sorted equally and generate a worklist for each user based on their hours but also detail which cases come from which list

IE

Worklist 1
then the case details

Worklist 2 then the case details. etc

Is this possible?

Can anybody please help. Im sure this would involve VBA but there are no experts in my office to ask. Any help on this matter would be very much appreicated.

Thanks

John