VBA: Search for text in database in copy cells within target rows

Hi,
I hope somebody can help me creating a macro for finding text values within a database.
I'm not so good in VBA, so I try this forum.

See attachment.
I want to know all notifications of a batch in my spreadsheet. The batch is in cell A1 and I want to look for this text in column D. The amount of hits can variate from batch to batch

Second, I want to copy the cells in the same row of the hits to another worksheet.
I can use the find and findnext function, but I'm not so good in implementing this all in a macro.

Can anybody help me with this issue ?

Try this:

Please Login or Register  to view this content.