Copy specific data to another sheet through VBA code

[keshavtale]

In the attached file you can see there is N column and Q column copy that both column data as it is
but if in Q column there is zero or blank cell then do not copy data of N column and Q column,
you can see in cell Q69 there is zero so i do not copy that data in to after sheet , you can see cell
Q92 is blank then also i dont copy that data , see after sheet i copy data manually in that sheet
so you can understand how to copy data but how do that process through VBA code.

[nankw83]

Hi keshavtale,

Try below code ...

Please Login or Register  to view this content.

[keshavtale]

Thanks now my problem is solved

[nankw83]

Glad to help & thanks for the added Rep. 👍🏼

[keshavtale]

can you do little change in that code i forget to tell you that if cell is blank in N column then do not copy data of Q column

[nankw83]

Just add the blue If condition to the previous code ...

Please Login or Register  to view this content.

[keshavtale]

thanks now my problem is fully resolved