COPYING MATCH CASES FIELDS FROM ONE FILE TO ANOTHER FILE

  • Am having two excel file ‘s (“A” & “B”)

    “A” is updated till now. (Taken from the server not having the comments or resolution filed)

    “B” is not updated till now. (Local Drive file with comments or status of incidents update)

    My intention is copying the fields from A to B which are not available in the B file. (only copy the fields which are not in B & It shouldn’t be disturbed the match cases of both A & B fields)

    After copying the not matched fields from A to B file and we will work on that and add comments or status filed to that unmatched cases everyday. So, it shouldn’t be disturbed the match cases in B file.

    Work fields columns from A to S

    In two files common field is “INCIDENT NO” which is in “B” Column.

    Please find sample sheets & do the needful.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!