Hello, I am trying to compare lists from two different sheets and then paste the variance on a new sheet, but it only seems to paste the last variance found.
Here are the specs:
Sheet 1 is called SerialNumSubReport
Sheet 2 is called PHYSICAL_VERIFICATION
Sheet 3 is called RESULTS
Sheet 1 contains a report output that includes serial numbers in Column G, Sheet two contains serial numbers physically found in column A (these will be entered by the user), Sheet 3 will contain a list of the Serial number(s) that are on sheet 1 but can not be found on Sheet 2.
Right now my code is as follows, but it only returns the last variance, not a list of the variances. I'm sure I'm messing up something in the loop, but I'm very new to VBA so I can't quite figure it out.
Any Thoughts? I also attached a copy of the macro document, with sample data included.
Bookmarks