Copy corresponding cell if value is >0

[Kashyap]

Hi,

How can I copy corresponding cell if value in Col E >0..? Something like
below.

Col D |Col E
ABC |12
MNO |2
HTR |0
UTV |0
HNC |5
XYZ |6
QTR |2
GTR |0
MTR |8


Result:

Col D |Col E
ABC |12
MNO |2
HNC |5
XYZ |6
QTR |2
MTR |8

 

[Shane Devenshire]

Hi,

You could apply an AutoFilter and filter on not equal to 0, then copy the
results to a new location

 

[Kashyap]

Hi Shane,

I cannot use auto filter there as the whole report is automated.

Can you suggest me any other way of doing this?

Thanks

 

[Fred Smith]

What does an automated report have to do with it? If autofilter affects the
report, simply turn it off after you have done the copy.

Regards,
Fred.