Need to display only unique employee name in summary - need some corrections in below code

Hi team,

Need small alteration with below code (Attached macro file for your reference).
In details sheet I have employee “John” listed twice who is working under location “ARZN”. On clicking submit button in attached file, I need to have John displayed only once with qty as “187”.

Please advise.

Please Login or Register  to view this content.

add this macro to your code:

Please Login or Register  to view this content.

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,

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,