Neeraj, thank you for your quick and professional response and solution.
Regards,
Adam
Subodh Tiwari (Neeraj)
You're welcome Adam! Glad I could help.
And thanks for the feedback.
Rob Henson
Formula option, in column F:
=IF(AND(D2<>"",D2<>0),D2,E2)
Copy/drag down as far as required and then Copy and paste Values into column D.
Alternative with the screen shot data, copy all of column E data and then do paste Special on column D, choose Values and at the bottom left of the Paste Special window choose Skip Blanks. This will ignore any blank cell from the copied range and will leave the value in column D.
Regards,
Adam