(免費) 有冇人想學Excel formula, 或者想搵人幫手砌excel表
PeterStrange 2019-12-10 14:37:31 甴近平

Ads

三柒二十一 2019-12-11 00:13:28 留名學野
SSono 2019-12-12 18:13:10 想問如果A1:A4 合併左做標題,但B1:B4冇合併
點樣可以引用到B既數據?
PeterStrange 2019-12-12 18:22:53 B 冇合併點解引用唔到呢
SSono 2019-12-12 19:33:33 巴打, TG搵你
:^(
香城市民 2019-12-12 22:05:49 搭單問vba 野
:^(

想問如果要copy一張worksheet 去另一個workbook野話
有咩方法可以唔要formula 剩係copy value ?
(除左select all -> copy -> paste value 之外
:^(
:^(
:^(
)
Black_mirror 2019-12-13 00:37:59 此回覆已被刪除
如𨳊似柒 2019-12-13 00:39:29 借po
:^(


發動世界級遊行!Who stand with us世界巡遊!
https://lih.kg/1780766
- 分享自 LIHKG 討論區
成功的老媽子 2019-12-13 02:25:29 假設我有一份完整既data係sheet 1
有一部份data已經抽咗出黎擺係sheet 2
我想extract淨低既data出黎可以點做? (即係我想將sheet 1有而sheet 2冇既date generate出黎放係sheet 3)

sorry講到一舊舊 可以望下下面副圖做例子
:^(

我已有sheet 1 and sheet 2 想整個sheet 3出黎
請問有冇formula or excel tool可以好快做到 感謝巴打
:^(
你老母係唔係到? 2019-12-13 07:48:40 如果我想整個類似search嘅function for 點名用

有一張sheet有哂個人資料

我想第二張sheet 有個 Search: ()
()入面可能比人打個電話用vlookup搵翻條友出嚟,再咁個enter制佢就會自己升咗上去

例如:
1. Search: (99999999) - enter

2. Cheng Tai Man 99999999 01-01-1999
Search: ()

3. Cheng Tai Man (99999999) 01-01-1999
Search :(88888888) - enter

4. Cheng Tai Man 99999999 01-01-1999
Chan Siu Mei 88888888 01-01-1999
Search: ()

:^(
PeterStrange 2019-12-13 16:10:35 data 係 unique?

Ads

PeterStrange 2019-12-13 16:11:20 咪就係普通vlookup
你想問咩
:^(
:^(
:^(
你老母係唔係到? 2019-12-13 16:52:31 我想咁個enter制佢會自己save起一邊,得出嚟個結果唔會走
PeterStrange 2019-12-13 16:53:48 vba copy 過去
你老母係唔係到? 2019-12-13 17:51:45 Peter教下我啦
:^(
PeterStrange 2019-12-13 17:58:42 black mirror 兄召喚
:^(
成功的老媽子 2019-12-13 18:16:10
Black_mirror 2019-12-13 18:43:27 此回覆已被刪除
PeterStrange 2019-12-13 19:03:32 即係佢要留一格做input
每入一次lookup value, vlookup出左result 就自動paste value 去第2個column 度,一路累積

好似係
你老母係唔係到? 2019-12-13 19:16:42 全中
:^(
sdvsvsdav 2019-12-13 21:47:49
sub test()
dim wk1 as workbook
dim wk2 as workbook
dim sh1 as worksheet
dim sh2 as worksheet

set wk1 = thisworkbook
set sh1 = wk1.worksheets("Sheet1")

set wk2 = workbooks.add
set sh2 = wk2.worksheets("Sheet1")

sh1.range("A1:B2").copy destination:=sh2.range("A1:B2")
end sub

Ads

sdvsvsdav 2019-12-13 21:51:45
搭單問vba 野
:^(

想問如果要copy一張worksheet 去另一個workbook野話
有咩方法可以唔要formula 剩係copy value ?
(除左select all -> copy -> paste value 之外
:^(
:^(
:^(
)
Paste:=xlPasteValues
sub test()
dim wk1 as workbook
dim wk2 as workbook
dim sh1 as worksheet
dim sh2 as worksheet

set wk1 = thisworkbook
set sh1 = wk1.worksheets("Sheet1")

set wk2 = workbooks.add
set sh2 = wk2.worksheets("Sheet1")

[s]sh1.range("A1:B2").copy destination:=sh2.range("A1:B2")[/s]
sh2.Range("A1:B2").Value2 = sh1.Range("A1:B2").Value2
end sub

sorry, did not see that you only need values
sdvsvsdav 2019-12-13 21:52:59
sub test()
dim wk1 as workbook
dim wk2 as workbook
dim sh1 as worksheet
dim sh2 as worksheet

set wk1 = thisworkbook
set sh1 = wk1.worksheets("Sheet1")

set wk2 = workbooks.add
set sh2 = wk2.worksheets("Sheet1")

sh2.Range("A1:B2").Value2 = sh1.Range("A1:B2").Value2
end sub

post again
香城市民 2019-12-13 23:54:55 另一個思路
:^(

星期一番去試下先
咸柑桔 2019-12-17 13:31:50 想問下如果我想sheet1既A1格有數值的話(數字或字母),sheet2既checkbox就會自動剔左
同埋我會有好幾個checkbox