How can copy data to bank cells only...

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,
I need to copy column A to column B, but only copy contain from cells a on column A to cells on column B only when cells on B are blank and leave the contains on non-blank cells on B alone. Thanks for your help.

KP


1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
you need a macro to do that or use a third column and use IF statement.