µù¥U
µn¿ý
º¶
½×¾Âª©³W
¸T¤î¦Cªí
»¡©ú
¦a¹Ï
¼Æ¦ì®Ñ»
¨p¤H®ø®§ (0)
¤½¦@®ø®§ (0)
½×¾Â¥ô°È (0)
¨t²Î®ø®§ (0)
¦n¤Í®ø®§ (0)
©«¤l®ø®§ (0)
³Â»¶®a±Ú°Q½×ª©ª©
»
Excel£¸¯ë°Ï
» ±N¿z¿ï²¾¦Ü¥t¤@¤u§@ªí
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
µo©«
[µo°Ý]
±N¿z¿ï²¾¦Ü¥t¤@¤u§@ªí
cw3076
µoµu®ø®§
¥[¬°¦n¤Í
cw3076
·í«eÂ÷½u
UID
147
©«¤l
42
¥DÃD
12
ºëµØ
0
¿n¤À
283
ª÷¿ú
283
ÂI¦W
2
§@·~¨t²Î
WINDOWS XP
³nÅ骩¥»
SP2
¾\ŪÅv
20
¨Ó¦Û
KAOHSIUNG
¦b½u®É¶¡
348 ¤p®É
µù¥U®É¶¡
2010-5-8
³Ì«áµn¿ý
2024-12-7
¤¤¾Ç¥Í
©«¤l
42
¥DÃD
12
ºëµØ
0
¿n¤À
283
ÂI¦W
2
§@·~¨t²Î
WINDOWS XP
³nÅ骩¥»
SP2
¾\ŪÅv
20
¨Ó¦Û
KAOHSIUNG
µù¥U®É¶¡
2010-5-8
³Ì«áµn¿ý
2024-12-7
1
#
¸õÂà¨ì
»
˧Ǭݩ«
¥´¦L
¦rÅé¤j¤p:
t
T
µoªí©ó 2011-4-30 13:35
|
¥u¬Ý¸Ó§@ªÌ
[µo°Ý]
±N¿z¿ï²¾¦Ü¥t¤@¤u§@ªí
Dear ¤j¤j,
§Ú¦³¤GÓ¤u§@ªí, ¤@Ó¦s©ñ¸ê®Æ
¤@Ó©ñ¹Ïªí, ¸ê®Æ³¡¥÷¦³¨Ï¥Î¿z¿ï¥\¯à
·Q¬Ý¤£¦Pidªº¹Ïªí³£¶·¨ì¸ê®ÆªºSheet¨Ï¥Î¿z¿ï,
¦³¨S¦³¿ëªk±N¿z¿ï²¾¦ÜChart ªº¤u§@ªí©O?
¤U¸ü
(31.16 KB)
2011-4-30 13:34
Book1.zip
(12.88 KB)
¤U¸ü¦¸¼Æ: 12
2011-4-30 13:35
¼Ó¥D¼ö©«
¤å¦rÂà®É¶¡®æ¦¡
With Application.FileSearch µLªk¨Ï¥Î
¨Ï¥ÎVlookup + Offset ¸Ñ¤G±ø¥ó
¨Ì¦æ¦C¸ê®Æ¬d¸ßªí®æ¤º®e
´M§ä¥¢¸¨ªº®y¼Ð
¿é¤J¤é´Á´M§ä¬Û¹ïÀ³ªº¦C¸¹
[Updateªþ¥ó]¸ê®Æ®æ¦¡±Æª©
¨â¦C¤§È¬Û¦P
Worksheet_Change ±ø¥óIJµo°ÝÃD
Sumproduct °ÊºA½d³ò³]©w
¦¬ÂÃ
¤À¨É
cw3076
µoµu®ø®§
¥[¬°¦n¤Í
cw3076
·í«eÂ÷½u
UID
147
©«¤l
42
¥DÃD
12
ºëµØ
0
¿n¤À
283
ª÷¿ú
283
ÂI¦W
2
§@·~¨t²Î
WINDOWS XP
³nÅ骩¥»
SP2
¾\ŪÅv
20
¨Ó¦Û
KAOHSIUNG
¦b½u®É¶¡
348 ¤p®É
µù¥U®É¶¡
2010-5-8
³Ì«áµn¿ý
2024-12-7
¤¤¾Ç¥Í
©«¤l
42
¥DÃD
12
ºëµØ
0
¿n¤À
283
ÂI¦W
2
§@·~¨t²Î
WINDOWS XP
³nÅ骩¥»
SP2
¾\ŪÅv
20
¨Ó¦Û
KAOHSIUNG
µù¥U®É¶¡
2010-5-8
³Ì«áµn¿ý
2024-12-7
2
#
µoªí©ó 2011-4-30 15:19
|
¥u¬Ý¸Ó§@ªÌ
·PÁ®L¤j´£¨Ñªº¸Ñµª ^.^
¦]¬°ì©l¹Ïªí¦³°µ°ÊºA¸ê®Æ¶b¤Î½d³òªºÅܤƩҥH·Q°Ý
¦³¨S¦³¿ëªk±N¿z¿ï²¾¦ÜChart ªº¤u§@ªí?
TOP
chin15
µoµu®ø®§
¥[¬°¦n¤Í
chin15
·í«eÂ÷½u
UID
3937
©«¤l
227
¥DÃD
3
ºëµØ
1
¿n¤À
273
ª÷¿ú
273
ÂI¦W
0
§@·~¨t²Î
XP
³nÅ骩¥»
XP
¾\ŪÅv
20
©Ê§O
¤k
¦b½u®É¶¡
30 ¤p®É
µù¥U®É¶¡
2011-3-22
³Ì«áµn¿ý
2013-1-29
¤¤¾Ç¥Í
©«¤l
227
¥DÃD
3
ºëµØ
1
¿n¤À
273
ÂI¦W
0
§@·~¨t²Î
XP
³nÅ骩¥»
XP
¾\ŪÅv
20
©Ê§O
¤k
µù¥U®É¶¡
2011-3-22
³Ì«áµn¿ý
2013-1-29
3
#
µoªí©ó 2011-4-30 20:39
|
¥u¬Ý¸Ó§@ªÌ
§ï¥Î¶i¶¥¿z¿ï¡Aª½±µ§â¿z¿ïµ²ªG©ñ¨ì§Anªº¤u§@ªí¤W§Y¥i¡C
TOP
ÀR«ä¦Û¦b :
¦³¦h¤Ö¤O¶q´N°µ¦h¤Ö¨Æ¡A¤£n¤ß¦sµ¥«Ý¡Aµ¥«Ý¤~·|¸¨ªÅ¡C
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
EXCEL±MÄÝ°Q½×°Ï
Excel£¸¯ë°Ï
Excelµ{¦¡°Ï
¶i¶¥À³¥Î±M°Ï
OFFICE ¨t¦C
Word
PowerPoint
Access
Office¤£¤À°Ï
µ{¦¡»y¨¥
VB »P VB.Net
C »P C#
Java »P J#
µ{¦¡³]p¤£¤À°Ï
¸ê®Æ®w
ORACLE
My SQL
MS SQL
ºô¶³]p
ASP »P ASP.NET
PHP
PHP+MySQL ¤Jªù¹ê§@
JavaScript
FLASH / ActionScript
HTM/ HTML/ CSS
ºô¶³]p¤£¤À°Ï
¹q¸£»P§@·~¨t²Î
¹q¸£¦UºØµwÅé°Q½×
¤@¯ë¹q¸£³nÅé°Q½×
½×¾Â¨Æ°È
ºÞ²z¤½§i
§ë¶D¤Ï¬M
·s¤â´ú¸Õ
·R ¡E ¥Í¬¡
¤½¯q§G§iÄæ
¥Í¬¡»P·P°Ê
[¦¬Âæ¹¥DÃD]
[Ãöª`¦¹¥DÃDªº·s¦^´_]
[³q¹L QQ¡BMSN ¤À¨Éµ¹ªB¤Í]
¥Ó½Ð¤Í±¡Ãì±µ
Facebook¯»µ·