I have another challenging idea which of course need help from you talented guys.
Now that it is able to copy everything (from k1 to the last cell). Is it possible to skip the cell (blank the cell) in column K if the cell in column J is blank:
example:
if J1:J10 contains value, copy K1 down to K10
if J11:J15 contains no value, K11:K15 should be blank as well
if J16:J20 contains value, K16 down to K20 should contain the value of K1.
Thanks again. Please help.
Bookmarks