Hello everyone,
I have a big ask that I cant seem to figure.
In the attached example, you will see 2 tabs,
The first tab (Raw), contains the raw data that I paste.
The second tab (Dashboard) is where i want to assign the raw data based on the condition of the table Dashboard!A2:I8. Which contains the names of the people i want to assign the cases to, based on the country.
So for example, the first name is Janet, where in which i put the value 3 in IT and 5 in the CN cell, meaning i want to assign the person 3 cases that have the IT as a country and 5 that have CN as a country.
So in the bellow table, i wanted the persons name to be shown in the first row, and the data matching the criteria set in the above table.
If you can see in the table in Dashboard! A10 downwards, the names automatically reflect the amount of cases i put in the above table, but i just dont know how to then apply the cases based on the country and number criteria.
Obviously would need to ensure that the same cases are not repeated, so if a case is assigned to someone, then it should not be assigned to anyone else.
I hope this makes some sense...
Bookmarks