Microsoft Excel - Filter

BusMan29

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.

BusMan29

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.

kkeennken

回覆 2# BusMan29

No.

bongbong3481

回覆 2# BusMan29

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

simontang

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

BusMan29

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.

happy_gemini

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

Vlookup might not help in this case.

bongbong3481

回覆 7# happy_gemini

我覺得樓主既情況，　寫ＶＢ　ＣＯＤＥ好似快過寫條公式

BusMan29

回覆  happy_gemini

我覺得樓主既情況，　寫ＶＢ　ＣＯＤＥ好似快過寫條公式 ...
bongbong3481 發表於 29-2-2016 20:51

I do not know programming.

bongbong3481

回覆 9# BusMan29

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