naruto
03-27-2007, 06:08 AM
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.
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.