VBA - copy cell if it is not empty

[Kristina96]

Hi everyone,

I have the following problem:
I have a small table with 2 columns (E and F):
I want to copy all values from column F into column E but only if there is a value in column F. I cannot use the "normal" copy function as that would copy empty cells. There are values in column E that are supposed to be kept if there is no value in column F.
All of this should be done with VBA as it is part of a macro.
I am very thankful for every idea or help!
Thank you and regards
Kristina

 

[Kristina96]

@Akuini: Amazing, it works now! Thank you so much!

 

[Akuini]

You're welcome, glad to help, & thanks for the feedback.

 

[Joe4]

That makes sense but it is still not copying the values. The macro is running without error but nothing changes...

That's odd, it worked just fine for me.
I have a feeling that there may be some minor detail that you are leaving out, not realizing that it may be affecting something.