VBA to find value anc create entire row

[forfiett]

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.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[forfiett]

Good day,

thanks for quick reply but is not working for me....
any other option?

[AB33]

Please Login or Register  to view this content.

[forfiett]

perfect! for now is working ..
will revert if any additional option will be needed.
THANKS

[forfiett]

Dears,

it is possible to ammend above code that will not copy entire row but only fm colum A to M

Thanks in advance

[AB33]

Please Login or Register  to view this content.

Please close the thread now as solved

[forfiett]

Dears,

it is possible to ammend bellow code so that if searched value in column will appear more times that will copy all rows where searched value is found??

Best ragards,
forfiett

[forfiett]

Normally, same values are in a sequence in a column.

[AB33]

fortfiett,
This thread is over a month old. If you do not close it, it will go for ever. The forum has designed in such away that a thread must be closed at some point. You can start a new thread, linking it with the old thread.
Please mark the thread as solved. If you have further questions, you should start a new thread.

Please Login or Register  to view this content.

[forfiett]

Dear,

it was marked a solved, but i need firther assistance so i unmarked it..

thanks for code but is not working...

please check: Rng.Offset(, -3).Resize(, 13).Copy

[AB33]

I have got the line from post#7.

[forfiett]

Finally it is working. Thanks.

Marked as solved.