Copy corresponding cell if value is >0

  • Thread starter Thread starter Kashyap
  • Start date Start date
K

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
 
Hi,

You could apply an AutoFilter and filter on not equal to 0, then copy the
results to a new location
 
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
 
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.
 
Back
Top