Hi.

this is an ongoing, feed so I can't use Filter
Can you explain that.. it would be much fast to:

1. Autofilter your range by column D for values >0.

2. Copy the visible rows after autofilter to the other sheet. No loop needed..

Why can't you use autofilter?