Compare Two Columns on Two Different Sheets and Paste the Results into a 3rd Sheet
I want to compare two different columns (A,C) on two different sheets (Sheet1, Sheet2) in the same workbook. If a column value in 'Sheet2' doesn't have corresponding column value in 'Sheet1' the corresponding row of mismatch value is copied to Sheet3, if that makes sense.
Any help would be appreciated as I am complete VBA noob.
It’s our mission to create a product that solves the huge challenges you face at work every day. In case you missed it, here are 7 delightful things we've added recently to monday to make it even more awesome.