I have data in 2 separate columns in 2 separate sheets..

Sheet 1 Sheet 2
Col A Col A
1 1
2 2
3 3
4 4
5 5
6 6
7 7
8 8
9 9
10
11
12
13

Result in Sheet 2, Col A
1
2
3
4
5
6
7
8
9

I want to delete all the rows in Sheet 2, Col A that are not present in Sheet 1, Col A using VBA


Please help.


Thanks.