Macro who copy the data from one sheet to another sheet basis of 2 other column cell value

Hello Guys,

I need help in creating a Macro which copy the data from one sheet to another sheet basis of 2 other column cell values.

The file is attached for your reference.

In attached file there are 2 sheets: “Data” and “Summary”.

I need a Macro which first check for the “Closed” cases in Data sheet Column E and then copy the “Client name” from Column C and paste it against the same “User Name” in Summary sheet who had his name in Data sheet Column G.

Some sample data has also been entered in the attached file and highlighted also.

Please refer the attachment for more clarity on the requirement.

Thanks for your help in advance.

Regards,
MG

with this code behind sheet data
when in column E the value change to closed
the code will do the job.

Please Login or Register  to view this content.

Kind regards
Leo

Maybe:

Please Login or Register  to view this content.