Below is the data in my two different sheets:
Workbook1
[TABLE="width: 500, align: left"]
<tbody>[TR]
[TD]LastName[/TD]
[TD]FirstName[/TD]
[TD]NewPermission[/TD]
[/TR]
[TR]
[TD][TABLE="width: 177"]
<tbody>[TR]
[TD="class: xl64, width: 177"]Aadhi[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 152"]
<tbody>[TR]
[TD="class: xl66, width: 152"]Vetrivel[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 240"]
<tbody>[TR]
[TD="class: xl66, width: 240"]Risk Quality Reviewer II[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 177"]
<tbody>[TR]
[TD="class: xl66, width: 177"]Abudhahir[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 152"]
<tbody>[TR]
[TD="class: xl66, width: 152"]Imrana Parveen[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 240"]
<tbody>[TR]
[TD="class: xl66, width: 240"]Risk Reviewer II[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 177"]
<tbody>[TR]
[TD="class: xl66, width: 177"]Achari[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 152"]
<tbody>[TR]
[TD="class: xl66, width: 152"]Deepthi[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 240"]
<tbody>[TR]
[TD="class: xl66, width: 240"]Risk Quality Reviewer II[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
Workbook2
[TABLE="width: 500"]
<tbody>[TR]
[TD]LastName
[/TD]
[TD]FirstName[/TD]
[TD]CurrentPermission[/TD]
[/TR]
[TR]
[TD]Aadhi[/TD]
[TD]Vetrivel[/TD]
[TD]Read Only[/TD]
[/TR]
[TR]
[TD]Abudhahir[/TD]
[TD]Imrana Parveen[/TD]
[TD]Read Only
[/TD]
[/TR]
[TR]
[TD]Achari[/TD]
[TD]Deepthi[/TD]
[TD]Read Only[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
What I want to achieve:
I want to be able to search Workbook2 based on LastName and FirstName column coming from Workbook1 and get the NewPermission value and then replace the value of CurrentPermission column in Workbook2 with that of the NewPermission value.
Please advice an easy and efficient way to achieve this as I have to do this for over 1000 rows on regular basis.
Thank you so much for all of your help in advance.
Workbook1
[TABLE="width: 500, align: left"]
<tbody>[TR]
[TD]LastName[/TD]
[TD]FirstName[/TD]
[TD]NewPermission[/TD]
[/TR]
[TR]
[TD][TABLE="width: 177"]
<tbody>[TR]
[TD="class: xl64, width: 177"]Aadhi[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 152"]
<tbody>[TR]
[TD="class: xl66, width: 152"]Vetrivel[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 240"]
<tbody>[TR]
[TD="class: xl66, width: 240"]Risk Quality Reviewer II[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 177"]
<tbody>[TR]
[TD="class: xl66, width: 177"]Abudhahir[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 152"]
<tbody>[TR]
[TD="class: xl66, width: 152"]Imrana Parveen[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 240"]
<tbody>[TR]
[TD="class: xl66, width: 240"]Risk Reviewer II[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 177"]
<tbody>[TR]
[TD="class: xl66, width: 177"]Achari[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 152"]
<tbody>[TR]
[TD="class: xl66, width: 152"]Deepthi[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 240"]
<tbody>[TR]
[TD="class: xl66, width: 240"]Risk Quality Reviewer II[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
Workbook2
[TABLE="width: 500"]
<tbody>[TR]
[TD]LastName
[/TD]
[TD]FirstName[/TD]
[TD]CurrentPermission[/TD]
[/TR]
[TR]
[TD]Aadhi[/TD]
[TD]Vetrivel[/TD]
[TD]Read Only[/TD]
[/TR]
[TR]
[TD]Abudhahir[/TD]
[TD]Imrana Parveen[/TD]
[TD]Read Only
[/TD]
[/TR]
[TR]
[TD]Achari[/TD]
[TD]Deepthi[/TD]
[TD]Read Only[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
What I want to achieve:
I want to be able to search Workbook2 based on LastName and FirstName column coming from Workbook1 and get the NewPermission value and then replace the value of CurrentPermission column in Workbook2 with that of the NewPermission value.
Please advice an easy and efficient way to achieve this as I have to do this for over 1000 rows on regular basis.
Thank you so much for all of your help in advance.