mardi 15 octobre 2019

VBA - Copy cell if not empty

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

Aucun commentaire:

Enregistrer un commentaire