I have two excel sheets. Sheet 1 has roughly 2400 rows (and will continue to grow) and sheet 2 has roughly 4400 rows (and will also continue to grow. Sheet 1 has one column and sheet 2 has 2 columns (but I only care about the first column). I need to compare sheet 1 and sheet 2 and be able to see what sheet 1 values are NOT in sheet 2. Ideally, this data would then populate a new sheet 3.
I have searched through many sites and many pages here with stackflow, but because I am so new at this, I'm not sure if I have come across what I need or not. Everything I have tried is not working.
Any help would be greatly appreciated!!