Copy and paste the data if condition met

rider@1234 · Apr 21, 2020

[FONT=&quot]All files are located in different path[/FONT]
[FONT=&quot]vba will be placed in a macro.xlsm[/FONT]
[FONT=&quot]i have a file name 1.xls & 2.xls[/FONT]
[FONT=&quot]match column I of 1.xls with column B of 2.xls[/FONT]
[FONT=&quot]If column I of 1.xls matches with column B of 2.xls then do nothing &[/FONT]
[FONT=&quot]if column I of 1.xls doesnt matches with column B of 2.xls then copy and paste the column B & Column I of 1.xls to column A & column B of sheet2 of 2.xls[/FONT]
[FONT=&quot]sheet name can be anything[/FONT]
[FONT=&quot]plz see the sample pic & help me in solving this problem by vba[/FONT]

rider@1234 · Apr 30, 2020

Problem Solved

p45cal · Apr 30, 2020

rider@1234, as a prolific cross poster without providing links, you need to read this:
http://www.excelguru.ca/content.php?184
and in future act differently

Copy and paste the data if condition met

rider@1234

Banned

Attachments

rider@1234

Banned

p45cal

Super Moderator