I'm using a macro to copy/paste (R:R} to (X:X). Is there a way to make it copy/paste only cells with text from (R:R)? - Don't copy/paste blank cells from (R:R) over cells in (X:X).
I already have data in many (X:X) cells also. I only want to copy over the cells from (R:R) that have data. If no data in (R:R) cell, I want to keep the current data in (X:X).
Thanks!
I already have data in many (X:X) cells also. I only want to copy over the cells from (R:R) that have data. If no data in (R:R) cell, I want to keep the current data in (X:X).
Thanks!