Comparing data values between worksheets *resolved*
I have a database that has two buttons that imports data from a table to a worksheet in excel. Each button copies different data to different worksheets.
My problem is that I have this data and I need to compare them for non duplicates and output that result in a third worksheet. An example will be given.
Worksheet 1
1
2
3
4
6
7
Worksheet 2
1
2
3
4
5
6
I need to compare worksheet 2 to worksheet 1 so that in worksheet 3 it gives me
5
I'm tried racking my brains on how to do this in excel, but I can't figure it out for the life on me. I know what i need to do but I don't know the right way about it
Puedsocode
If cells in Sheet2 is Not Equal to cells in Sheet 1 Then
Ouput result to worksheet3
End If
Any help would be great
Thanks