Announcement

Collapse
No announcement yet.

match columns between files

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • match columns between files



    My all files are located in same place
    macro will be placed in a seperate file
    file1.xlsx
    file2.xlsx
    Macro.xlsm
    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

  • #2


    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.
    Alan

    Did you debug your code first? http://www.cpearson.com/excel/DebuggingVBA.aspx
    FORUM RULES----->http://www.ozgrid.com/forum/announcement.php?f=8

    If someone has helped you, say "thank you" by clicking on the Like Button.

    Comment

    Working...
    X