I have attached the test data herewith for your reference. Requesting this solution to make the bulk reassingment of InProgress tasks to new resources easily
Please provide excel VBA code for below condition:
1. Find a word like "Apple","Oranges", "pineapple" and delete entire rows wherever this word is present; here i would like to find strings one by one automcatically using vba code; that is vba code will find apples first delete entire rows of apple ; then find oranges delete entire rows of orange etc.
2. After that, for the remaining lines, i need to fill the last column new resource reassingment based on project name like "apples", "oranges" etc.
One resource can have tasks from multiple random project names; like one resource will have one task from apple and one task from oranges etc.
Thanks for the time and support