Copy rows from workbook A to another workbook B based on the column value in workbook A

[addurisathvik]

Hi,

Could someone help me in achieving this. I require this to accomplish my project task. I am still a beginner in writing VBA and did lot of research over the internet and still empty handed.

I have the below data in workbook A in worksheet Sheet1.

EMP ID EMP NAME JOB TITLE 101 James Software Engineer 546 Samuel Designer 324 Xavier Technician <colgroup><col><col><col></colgroup><tbody> </tbody>

<tbody>
</tbody>

I have the below data in workbook B in worksheet Sheet1.

EMP ID EMP NAME JOB TITLE 101 James Software Engineer 145 Robert System Analyst 546 Samuel Web Developer 324 Xavier Technician 345 Rachel Researcher <tbody> </tbody>

<tbody>
</tbody>

I need a macro where i need to search the EMP ID present in Column A in the workbook A and find the same in Column A in the workbook B. When matched i want to copy the entire row for that EMP ID from workbook A and overwrite in the workbook B. If no match found i want to insert new row in the workbook B.

Please help me.


Thanks,

Sathvik

 

[addurisathvik]

Please help.

 

[addurisathvik]

Anyone ?

 

[addurisathvik]

No one ?