Hi,
Macro will be placed in macro.xlsm & book1.xlsx & book2.xlsx are loacted at different path so the path should be hardcoded in the macro so that i can change it as per my needs
If cells of column A of book1.xlsx matches with cells of column A of book2.xlsx then dont do anything & if it doesn't matches then copy that unmatched data from cells of column A of book1.xlsx & paste it to unmatched cells of column A of book2.xlsx
Kindly hardcode the column A of both the files in the macro so that i can change it as per my needs
Thnx
Bookmarks