I've done a few searches and couldn't really find what i need.
I'm not familiar with VB, but if given code, i could probably copy and paste and debug from there.
I've got two .CSV files that i want to compare, and make a third .CSV file.
File A, contains a list of information. column B will contain a name, and column C will contain another name, which is part of the name in Column B.
File B will contain a list of similar names, with the same format and everything.
What i'm looking for is a formula or macro that will create a third document that contains all of the information that is in File B, and add the rows of information that are in File A, but not in File B. This should be done by comparing the name in Column B in File A to Column B in File B. If a name in Column B from File A is not in File B, then the entire row should be copied to File C, with the name in Column B change to "Removed".
I now it's possible to make something like this, and i can explain the logic a little better if needed, but a nudge in the right direction would be very helpful.
I'm not familiar with VB, but if given code, i could probably copy and paste and debug from there.
I've got two .CSV files that i want to compare, and make a third .CSV file.
File A, contains a list of information. column B will contain a name, and column C will contain another name, which is part of the name in Column B.
File B will contain a list of similar names, with the same format and everything.
What i'm looking for is a formula or macro that will create a third document that contains all of the information that is in File B, and add the rows of information that are in File A, but not in File B. This should be done by comparing the name in Column B in File A to Column B in File B. If a name in Column B from File A is not in File B, then the entire row should be copied to File C, with the name in Column B change to "Removed".
I now it's possible to make something like this, and i can explain the logic a little better if needed, but a nudge in the right direction would be very helpful.