asked on Formula in Excel or vba to transfer values from Column X to Y
I have to transfer the values in Col E to Col D without overwriting the values in Col D if values exists in cells.
The value = 0 or all empty cells in Col. D should be overwritten by the values from Col. E
Filter, Copy & Paste is a bit difficult if I have 50000 rows.
![Screen]()
As always thank you for you assistance and effort.
Regards
Adam
Sample.xlsx
The value = 0 or all empty cells in Col. D should be overwritten by the values from Col. E
Filter, Copy & Paste is a bit difficult if I have 50000 rows.
As always thank you for you assistance and effort.
Regards
Adam
Sample.xlsx
Microsoft ExcelVBAVB ScriptMicrosoft Office
Last Comment
Adam Elsheimer
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
You're welcome Adam! Glad I could help.
And thanks for the feedback.
And thanks for the feedback.
Formula option, in column F:
=IF(AND(D2<>"",D2<>0),D2,E
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.
Thanks
Rob H
=IF(AND(D2<>"",D2<>0),D2,E
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.
Thanks
Rob H
ASKER
Thank you Rob. I just noted this fomular for future project. Thanks all of you so much for helping.
Regards,
Adam
Regards,
Adam
Regards,
Adam