Excel VBA row delete if cell contaion specific value from sheet2

[zsolti900]

Hello All,

I would like do something like, what can remove the row, if 1 cell contaion the value from sheet2. For example:
Sheet1:
A A A
1 a 1 1
2 b 2 2
3 c 3 3
4 d 4 4

Sheet2:

A
1 specific value:
2 2
3 4

And when i run the VBA this just gonna remove the 2. and 4. row and i will get something like this:
A A A
1 a 1 1
2 c 3 3


I would like work with table, so thats why the filter not good idea. Thank you very much!

 

[DanteAmor]

I don't understand how the data is in the cells.
You could put an image or better yet an example of your data with the XL2BB tool.