Delete rows in Sheet A if any conditions found in Sheet B met

Hi All experts,

I am trying to write a macro where it will delete rows in Sheet A if any condition is found in the row which is based of conditions in Sheet B.

Eg

Sheet A :

Column A Column B Column C Column D
1234 ABC tyu 4588
asd qwe www 4455
zxc zdaa 1234 4441
ghj llll 1111 poo0

(And many more....)

Sheet B (where i kept my conditions in Column A: )

Column A
1234
1111
(and many more....)

So for this instant , the end results will be the Row 1 and row 4 will be deleted. I have tried to google but most only contains deleting rows with a specific conditions.

Any 1 can help me please ?

Thanks,

Hi Sweep,

Thanks for your time in reading this. Yes it should be deleted too .

Thanks again!

Thanks Sweep !

It seems that i have to clicked numerous times before the related rows get deleted and also I noticed that it only delete the row if the condition is found in Column A in Sheet A ?

We are getting there , really appreciate your help

Thanks

Also, somehow i also encountered this error Run time error '424': Object required while repeating the macro .

Thanks Sweep and watersev for trying to help.

I realized something wrong with my request and actually what i wanted to achieve is in Sheet A , there will be multiple Headers ( A to I ) and the line after the headers will have a sub heading. What i need is actually a macro to look under sub header BOOK and see whether any of it matches the condition in B.

The sub header book is different in each Main header and the number of lines for each heading varies.

Attached is the worksheet. Able to help mates ?

Thanks

option, please check attachment, run code "test"

Thanks alot for your help watersev !

Excellent , its working perfectly now!

Cheers!