Search & copy results to new sheet

[Tom2020]

Hello
I am looking for a VBA solution and hope someone can help me.
In a sheet, it should use input-box to search text and number. If it finds desired result(s) in a Range (A10:H3000), it should copy the whole row to the cell to the new sheet (start with A10), and highlight results (text or number) with Red.
This search should repeat
Thx for your help
Tom

 

[Sahak]

“after 2023” “gifts this year” “mrexcel” All works

 

[Tom2020]

“after 2023” “gifts this year” “mrexcel” All works

Hi Sahak
I found the bug led to the search results being incorrect.

I would like to thank you and appreciate your help.

tom

 

[Sahak]

You are welcome.