(免費) 有冇人想學Excel formula, 或者想搵人幫手砌excel表

1001 回覆
297 Like 23 Dislike
2019-12-10 14:37:31
甴近平
2019-12-11 00:13:28
留名學野
2019-12-12 18:13:10
想問如果A1:A4 合併左做標題，但B1:B4冇合併
點樣可以引用到B既數據？
2019-12-12 18:22:53
B 冇合併點解引用唔到呢
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 之外)
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: ()

2019-12-13 16:10:35
data 係 unique?
2019-12-13 16:11:20
咪就係普通vlookup
你想問咩
2019-12-13 16:52:31
我想咁個enter制佢會自己save起一邊，得出嚟個結果唔會走
2019-12-13 16:53:48
vba copy 過去
2019-12-13 17:51:45
Peter教下我啦
2019-12-13 17:58:42
black mirror 兄召喚
2019-12-13 18:16:10
係
2019-12-13 19:03:32
即係佢要留一格做input
每入一次lookup value, vlookup出左result 就自動paste value 去第2個column 度，一路累積

好似係
2019-12-13 19:16:42
全中
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
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
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
吹水台自選台熱　門最　新手機台時事台政事台World體育台娛樂台動漫台Apps台遊戲台影視台講故台健康台感情台家庭台潮流台美容台上班台財經台房屋台飲食台旅遊台學術台校園台汽車台音樂台創意台硬件台電器台攝影台玩具台寵物台軟件台活動台電訊台直播台站務台黑　洞