Good day to all.

I need a macro that will search a value in column D (sheet2) that is noted in cell C7 on sheet3.
Afterthat it must copy enitre entire row where searched value was found to sheet3, last empty row.

an example:

entered value in cell C7 on sheet 3 is ABC
on Sheet2 column D, value ABC was found in cell 150 (D150) so it has to copy for 150 to sheet3, last empy row.

How to od it?

Thanks.