Suppose File A has 10 rows at column C. After filtering, only Row 1, 2, 6, 7, 9 are shown. Then, I need to copy the values of a column from File B to File A. At File B, there are 5 rows which has values and need to copy to File A. But, it is failed. Only Row 1, 2 have value while Row 6, 7, 9 have no value. Please advised if there is any way to copy those 5 rows to the filtered cells directly. Thank you.