Code to copy data but ignore any cels with zero

[ZeDoctor]

Hi guys,

I've got a code set up that copies about 15 rows of data currently. The problem I have is that I don't want all these columns copied.

Some times we might have data in 1 out the 15 columns, other times we might have data in 12 out the 15. if data isn't present in a row column B will always have a zero in it and this means that any rows below this will also have zeros and be empty. So im basically looking for the first zero in a column and taking all rows above this zero.

Any ideas?

Please Login or Register  to view this content.

[pareshj]

Hi ZeDoctor,

Use can filter out Column B which are non zeros and copy that filtered rows to worksheet of another workbook.

Following is the code sample to copy and paste the filter rows :

Please Login or Register  to view this content.

Regards,
Paresh J