Hi,
Thanks for the code, but your code removes the duplicate names from details sheet which is not the thing I'm expecting. What I need is , if same employee is working under two different locations, then it should display the employee name twice, similarly if under same location employee is listed twice then it should sum the qty and display the name only once,