Allacation of Data

[SDUNA76]

I have a list of 1000'cases' for staff to work on and I want to auto allocate them to people. Some case are hold by worker previously

The main data is on one page and each person has their own individual page for their cases for the day. Is there any way to avoid multiples being sent out whilst creating a kind of 'priority ladder' as such?

[Punnam]

Hi SDUNA7,

upload a sample workbook with out any confidential data , Showing your requirement manually for a particular case.

Punnam