Vba code to copy paste full row if condition is met

[kv.singh]

I want to copy whole row from sheet 'NB' to sheet "DATA'' if column M of sheet 'NB' matches text written in cell "C2" of "BONUS'' sheet. I want to overwrite data in sheet "DATA" every time I run VBA code.

I will be thankful to you if someone can provide VBA code for above mentioned project.

[maras_mak]

Try.

Please Login or Register  to view this content.

[kv.singh]

Code if working fine. only one problem is Ithat want to overwrite data in sheet "DATA" every time I run VBA code. present code is appending data in sheet"DATA". Every time I have to delete previous data before running vba code.

[nankw83]

This is another option …

Please Login or Register  to view this content.

[maras_mak]

The corrected code.

Please Login or Register  to view this content.

[kv.singh]

Thanks NANKW83 your code is giving desired result.
Now If I want to copy whole row from sheet 'NB' to sheet "DATA'' if column M of sheet 'NB' matches text written in cell "C2"or
OR "C3" OR "C4" of "BONUS'' sheet. what changes Ii have to make in present code.

[kv.singh]

sorry Sir, correct question is " If I want to copy whole row from sheet 'NB' to sheet "DATA'' if column M of sheet 'NB' matches text written in cell "C2"and
and "C3" and "C4" of "BONUS'' sheet. what changes I have to make in present code.

[nankw83]

Try now …

Please Login or Register  to view this content.

[kv.singh]

Excellent. Thanks a lot. My problem is solved.

[nankw83]

Glad to help … Please mark this thread as 'SOLVED' & consider giving Reputations to those who have helped by clicking the star under their usernames

[Vraag en antwoord]

The advanced filter has been devised for this. In the sheet 'BONUS' in C1 type 'AG' and run the following code:

Please Login or Register  to view this content.