vba code to copy/paste all except some from different worksheet

[abhi_jain80]

Hi folks,

I wrote a vba code which will copy/paste the details from A/B/C to the "Results" tab. The fields which are filled OR whose response is "Yes" will get copied from A/B/C and get pasted in the "Results" tab.

I need to opt out copy/paste some specific rows from A & B (as highlighted in green color) to the "Results" tab, just wondering how to do that?

Attaching the data along with the vba code. I look forward for your support please...

Thanks in advance...
Abhi

 

[Marc L]

Hi,​

​

according to the help you have received in other forums some weeks ago, what changes ?​

​

 

[abhi_jain80]

Hi,
I need to exclude some rows for copy/paste (as highlighted in the green color) from A & B worksheets.
Basically need one more filter based on background/font color.

Many Thanks.

 

[abhi_jain80]

Hi, did anybody got the chance to look into this please?

Thanks in advance...
Abhi