Macro not working properly for matching between sheet

Hi All,

I have two sheets Master and company_list available in below path

Master=''C:\temp"
Company_list="C:\QC\Responsibility"

I want to insert one column named as "Processing site" and populate data when User_fullname column from 'Master' workbook is matching with "name" column for sheet 'user' from other workbook 'Company_list'. I got the solution from this forum.

Now I have same type of requirement for other worksheet.

I want to insert one column named as "Priority" and populate data when ENAME column from 'Master' workbook is matching with "check" column for sheet 'processing' from other workbook 'Company_list'. I used the below macro but it is not working for few rows and its very slow.

Can you please help me.

Please Login or Register  to view this content.

My apology Alpha. I forgot to attach the correct sheet.

Request to check once

Thanks in advance