Microsoft Excel - Filter

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.

I have done 2 testing.

Testing 1: Success
After filtering, Row 1, 2, 6, 7, 9 has the same value at Column C.
Then, I highlight these values at Column D and copy to another file.
All values are copied successfully.

Testing 2: Failed
I copy 5 values at a column of 5 rows to the filtered cells.
I found that the values are copied to the first 5 rows.
It seems that I cannot copy to Row 1, 2, 6, 7, 9.

Is there any way to copied the values to those filtered rows? Thank you.

TOP

本帖最後由 kkeennken 於 2016-2-17 22:19 編輯

回覆 2# BusMan29

No.

TOP

標題

回覆 2# BusMan29

我會寫個vbs 去處理(我相信用excel 公式去做有d 難) ,首次取消filter,   然後一格一格咁由b file copy and paste 去A file 1 2 6 7 9,   最後再filter 番

TOP

you have such condition to filter, why don't use vlookup?

TOP

you have such condition to filter, why don't use vlookup?
simontang 發表於 18-2-2016 19:29

I do not know vlookup.
I think I have to Google.
HaHa.

TOP

you have such condition to filter, why don't use vlookup?
simontang 發表於 2016-2-18 19:29


Vlookup might not help in this case.

TOP

回覆 7# happy_gemini

我覺得樓主既情況, 寫VB CODE好似快過寫條公式

TOP

回覆  happy_gemini

我覺得樓主既情況, 寫VB CODE好似快過寫條公式 ...
bongbong3481 發表於 29-2-2016 20:51

I do not know programming.

TOP

回覆 9# BusMan29

好奇問一問, 咁你個問題解決左未?  如果用公式整, 介唔介意放條公式出黎參考下

TOP