I do a filtering, which is not blank and then copy the result to the column in the same sheets
however, when I paste the result if wont follow the row number, attached jped and coding for reference.
In case, I want to keep the value the the pasted column if it is blank, I can do it using for loop but its too slow as I got 200k rows and I need to do 20 columns.
.Range(“$A$7:$” & colbcMatch & “$” & bcFinalrow).AutoFilter Field:=colnbcsd, Criteria1:=”<>”
.Range(colbcSD & “7:” & colbcSD & bcFinalrow).SpecialCells(xlCellTypeVisible).Copy
Please notice that its only partial code, and all variables are well defined.