Please help in creating a 3rd worksheet which is the result of comparing 1st and 2nd worksheet.
The Sheet 1 has all the original info and consists of columns A & B. The Sheet 2 has new info and also has columns A & B. I would like the macro or program to first look at Sheet 2, compare/delete the data that matches in Sheet 1, list the data that matches only one column then, create
Sheet 3 with the new data. In another way it's like, Sheet 1 - Sheet 2 = Sheet 3
Thanks in advance...
The Sheet 1 has all the original info and consists of columns A & B. The Sheet 2 has new info and also has columns A & B. I would like the macro or program to first look at Sheet 2, compare/delete the data that matches in Sheet 1, list the data that matches only one column then, create
Sheet 3 with the new data. In another way it's like, Sheet 1 - Sheet 2 = Sheet 3
Thanks in advance...