match columns between files

  • My all files are located in same place
    macro will be placed in a seperate file
    we have to work with sheet1 of file1.xlsx and file2.xlsx(sheet1 name can be anything)
    we have to look column A of file1.xlsx and column A of file2.xlsx
    If the data in column A of file1.xlsx matches with column A data of file2.xlsx then delete that data in file2.xlsx and if not matches then copy that data from column A of file2.xlsx and paste it to column A of file1.xlsx
    i need to do this by vba so plz have a look sir

  • Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.