Comparing data values between worksheets *resolved*

[Decosta]

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