Automatic Distribution of Items based on Priority Level and Type Set!

Dear,

Please help me!!!!

Need to Automatically distribute Items based on priority level and type set for different People.


Find sample below


Type Name Priority Level Distributed Summary Items Type Distributed
VIP Mithun 1 4 Rubber Special Mithun
Special Jonathan 1 4 Sharpner Urgent Abhishek
High Sanket 2 3 Pencil High Sanket
Urgent Siddik 1 4 Pen Black Low Anita
Low Shajad 3 2 Pen Blue High Anooj
Anita 4 1 Pen Green Urgent Benazir
Anooj 2 3 Pen Red High Rummani
Dhruv 2 3 Highlighter Yellow Low Sreedhar
Sreedhar 4 1 Highlighter Orange Special Sujeet
Total Items Sujeet 1 4 Highlighter Green Special Jonathan
36 Benazir 3 2 Highlighter Blue Special Siddik
Abhishek 3 2 Stapler Special Sujeet
Rummani 2 3 Pin Special Siddik
Sheet A4 Special Mithun
Sheet A5 Special Siddik
Sheet A6 Special Jonathan
Sheet A7 Urgent Shajad
Sheet A8 High Dhruv
Note: If Additional Type VIP again distribute to Priority Level 1 Sheet A9 High Sanket
Sticky Note High Rummani
Punch Urgent Abhishek
Folder Cover High Sanket
Input Cells Automatic Cells Tissue Special Mithun
Type Items Stamp Pad Blue Special Jonathan
Name Distributed Stamp Pad Black Special Sujeet
Priority Distributed Summary Stamp Pad Red Special Mithun
Total Items Stamp Pad Green Special Jonathan
Stamp Pad Big High Anooj
Print Paper High Dhruv
Box File Urgent Benazir
Ciip File High Rummani
Envelope High Dhruv
Tray Urgent Shajad
Manager Tray Special Siddik
Calculator Special Sujeet
Tape High Anooj

Dear,

Thanks for your reply really appreciated. Find attached xls file

Dear,

Need help pleaseeee

Dear,

Where is the file in which you have performed the mentioned task

Dear,

Also the trick here is the priority level is also for the people too

Dear,

Just we have results if we meet 3 conditions.
1) Priority level 1,2,3,4,5 and 6 (People Names Column)
2) Type (VIP, SPECIAL, URGENT, HIGH, MEDIUM, LOW)
3) iTEMS COLUMN

Items which are categorized as Vip, Special, Medium etc will be divided into People who have different priority level set (1 to 6 High Priority to low Priority)