¦p¦ó¦bÀH®ÉÅܰʪº½d³ò·j´M²Å¦X±ø¥óªºÈ?
- ©«¤l
- 35
- ¥DÃD
- 7
- ºëµØ
- 0
- ¿n¤À
- 202
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2010-8-7
- ³Ì«áµn¿ý
- 2020-6-11
|
¦p¦ó¦bÀH®ÉÅܰʪº½d³ò·j´M²Å¦X±ø¥óªºÈ?
¥»©«³Ì«á¥Ñ alinne ©ó 2010-9-28 13:35 ½s¿è
±z¦n¡I
¦]¬°¦bºô¸ô¤W¤Î°Q½×ª©¤º·j´M¤F«Ü¤[¡A©Ò¥H·Q½Ð¦U¦ì«e½úÀ°¦£¡CY¦³§@ªk«Ý¥[±j³B¡A©|½Ð¤£§[´£ÂI¤F¡IÁÂÁ¡C
1.¥Î¨Ó·í¸ê®ÆÀɪº¤u§@ªí¡A¦]¤u§@»Ý¨D»Ý¨D·Q§â²Å¦X³æ¾Ú¸¹½XªººKn»¡©ú¤Î¬ÛÃö¸ê®ÆÂàºK¦Ü¥t¤@Ó¤½¥q¨î¦¡ªí®æ
¸ê®Æ¬OÀH®É·|¼W¥[ªº¡A(¥t½Ð±Ðvlookup¬O¤£¬O¤@©wn¨î½d³ò?¦]¬°§Ú¦pªG¨Ï¥Î¾ãÄæ(a¥¦¦n¹³³£·j´M¤£¨ì??)
§Ú²Ä¤@¦¸¨Ï¥Îvlookup¡]¦³¨î½d³ò¡^®É¡A«e±´Xµ§·|¦¨¥\¡A«á±´Xµ§¤S·j´M¤£¨ì...¡]¡Ö¡Ä¡Õ»ï¡^
½Ð°Ý¥i¥H«Øij¨Ï¥Î¤°»ò¤èªk©O¡H
2.Àɮפ¤¦³Ó·JÁ`ªí¡Aexcel¦³¿ìªk¦Û°Ê²Ö°Ê¬Y´Á¦¸(²Å¦XÄæa)«eªº©Ò¦³¼ÆȶÜ? ¨Ò:²Ö¥[990901´Á¤§«e©Ò¦³¼ÆÈ(«h¥]¬A990801¡B990802)
ÁÙ¬O¥u¯à¤â°Ê¿é¤J©O??
---------
¸É¤WÀÉ®×
Åܰʽd³òÂ^È.rar (41.36 KB)
ÁÂÁ¦U¦ìª©¥Dªº¼ö¤ß¦^´_
TO¡@oobirdª©¥D¡G
ÁÂÁ´£ÂI¡I¥H«áµo°Ý·|¦hª`·N¡A¸É¤WÀɮס]¦]¬°ÁÙ¨S§¹¥þ¾ã²z¦n¡A©Ò¥H¥»¨Ó¤£¦n·N«ä¤W¶Çªº¡ã ¡^
§Ú«á¨Ó¦A§ó·s¸ê®Æ«á¡Aµo²{§Ú®»¤£¨ì¦n¹³¥u¦³³Q§ÚÂà¶K¦¨"È"³¡¥÷ªº¸ê®Æ¡A¦]¬°§Úµo²¼½s¸¹¨ºÄæ¬O¥H¨ç¼Æ³]©w¦Û°Ê½s¸¹ªº¡A¸ê®Æ¦A©¹«á¸É®É¡A¬°§K¿z¿ï«á½s¸¹ÅÜ°Ê¡A©Ò¥H©ó¨C´Á³øªí´£¥X½T»{«á³£·|§â½s¸¹Âà¶K¦¨"È"ªº§ÎºA¡C
TO Hsieh ª©¥D¡G¦]¬°¿z¿ï«á§Ú¦Û°Ê½s¸¹ªºÄæ¥i¯à·|ÅÜ°Ê¡A¤£¹L§Ú·|©¹³oÓ¤è¦V¦A«ä¦Ò¬Ý¬Ý¡AÁÂÁ±z¡ã
TO¡@¦Ñ®Lª©¥D¡G
ÁöµM§Ú¥Îªº¬O2007ª©¥»±z¤£«K¦^´_¡A¦ý¬OÁÙ¬O«Ü·P¿E±z´£¨Ñ«Øij¤è¦Vò¡I |
|
¯à¤O¤£¨¬¡A§V¤O¼ç¶i¤¤¡IÁÂÁ¤j®aªº¤À¨É»P«ü¾É¡I
Alinne
|
|
|
|
|
- ©«¤l
- 35
- ¥DÃD
- 7
- ºëµØ
- 0
- ¿n¤À
- 202
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2010-8-7
- ³Ì«áµn¿ý
- 2020-6-11
|
¦^´_ 10# ¦Ñ®L
TO¡G®Lª©¥D
ÁÂÁ±zªº´£ÂI¡Iì¨Ó§Úªºªí®æ©|¥¼²Å¦X¸ê®Æ®w«Øºcì«h¡A·|¦AÀË°Qקï¡ã¡]Ãø©Ç§Úèè§ó·s¸ê®Æ«á¡Aì³]©wªº¼Ï¯Ã¤ÀªRªí¤¤ªº¼ÆȳºµM¦³º|¥¢....¡^ |
|
¯à¤O¤£¨¬¡A§V¤O¼ç¶i¤¤¡IÁÂÁ¤j®aªº¤À¨É»P«ü¾É¡I
Alinne
|
|
|
|
|
- ©«¤l
- 109
- ¥DÃD
- 22
- ºëµØ
- 0
- ¿n¤À
- 134
- ÂI¦W
- 0
- §@·~¨t²Î
- Win7
- ³nÅ骩¥»
- Office 2000
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_¥«
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2023-3-5
|
|
|
|
|
|
|
- ©«¤l
- 35
- ¥DÃD
- 7
- ºëµØ
- 0
- ¿n¤À
- 202
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2010-8-7
- ³Ì«áµn¿ý
- 2020-6-11
|
¦^´_ 8# ¦Ñ®L
TO¡G®Lª©¥D
ÁÂÁ±z@¤ßªº¦^´_ò! §ÚÂন97-2003ª©¥»«·s¤W¶Ç¤F~ÁÂÁ±z~ |
|
¯à¤O¤£¨¬¡A§V¤O¼ç¶i¤¤¡IÁÂÁ¤j®aªº¤À¨É»P«ü¾É¡I
Alinne
|
|
|
|
|
- ©«¤l
- 109
- ¥DÃD
- 22
- ºëµØ
- 0
- ¿n¤À
- 134
- ÂI¦W
- 0
- §@·~¨t²Î
- Win7
- ³nÅ骩¥»
- Office 2000
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_¥«
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2023-3-5
|
ÂàXLSÀÉ
XLSXÀÉ
ª©ExcelµLªk¶}±Ò±Ò |
|
|
|
|
|
|
- ©«¤l
- 35
- ¥DÃD
- 7
- ºëµØ
- 0
- ¿n¤À
- 202
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2010-8-7
- ³Ì«áµn¿ý
- 2020-6-11
|
ÁÂÁ¦U¦ìª©¥D~§Ú«·s¤W¶Ç¤F¥b¦¨«~ªºÀÉ®×(²Û)
§Ú¦³§â¦³°ÝÃDªº³¡¥÷¥H«G¶À¦â¶ñ©³¤F...§Æ±æ³o¼Ë¯à¤ñ¸û²M·¡ªí¹F§Úªº°ÝÃD
¤£¹L§Úì¤W¶Çªº¹Ï....¨S¦³§R¨ì...»ï»ï(©êºp!) |
|
¯à¤O¤£¨¬¡A§V¤O¼ç¶i¤¤¡IÁÂÁ¤j®aªº¤À¨É»P«ü¾É¡I
Alinne
|
|
|
|
|
- ©«¤l
- 109
- ¥DÃD
- 22
- ºëµØ
- 0
- ¿n¤À
- 134
- ÂI¦W
- 0
- §@·~¨t²Î
- Win7
- ³nÅ骩¥»
- Office 2000
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_¥«
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2023-3-5
|
¦Û°Ê¿z¿ï¤§¤U¸¨¦¡¿ï³æ
«½Æ¸ê®Æ¤¤Åã¥Ü¤£«½Æ¤§¿ï³æ³Ì¦hÅã¥Ü1000Ó
¼Ï¯Ã¤ÀªRªí©ÔÄæ¦ì¦Ü[¦C,Äæ,¤À¶]°Ï,´N¬O·F³o¥ó¨Æ,¤¹³\¦hÄæ¦ì¦Û°Ê°µ[ã«h]
¨ä¥\¯à´«Ó»¡ªk,´N¬O±N©Ò¦³¸ê®Æ,¦C¥X©Ò¦³[ã«h],µM«ápºâ[SUBTOTAL()]
¸ê®ÆÁY´î«á,¦A°µ±Æª©¤u§@
¥i¥H¤@¨c¥Ã¶hªº¨Æ,¨Ã¤£»Ýn¨C¤é¥h³]©w¼Ï¯Ã¤ÀªRªí
¨ú¸ê®Æ¥u»ÝnÂùÀ»©Ô©Ô
***********************************************************************
1.°ÊºARange§@ªk©w¸q¦WºÙ¥ÎOFFSET()¼gµ¹¼Ï¯Ã¤ÀªRªí,¨Ó·½¸ê®Æ¨Ï¥Î
2.¨Ï¥Î¥~³¡¸ê®Æ¬d¸ßºëÆFÂà±µ¦Ü¼Ï¯Ã¤ÀªRªí
°O±o¤Ä¿ï¨t²Îªí®æ§_«h·|§ä¤£¨ì¸ê®Æªí
±Ð¾Ç¿ý¼v±a¥u±Ð©ÔÄæ¦ì
¨Ã¥¼»¡©ú¬O¦b·F¬Æ»ò¨Æ
¨Ï¥ÎªÌ¬O¦³¬Ý·d¤£À´
************************************************************************
³o´N¬O¤j®a¤£·|¨Ï¥Î¼Ï¯Ã¤ÀªRªí¤§¥Dnì¦]
¦]¦Ó©ñ±ó¾Ç²ß
Âà¦V¾Ç²ßVBA,¾Ç²ß¨ç¼Æ
±Ë²¦Ó´NÁc
¶V·d¶V½ÆÂø |
|
|
|
|
|
|
- ©«¤l
- 1572
- ¥DÃD
- 16
- ºëµØ
- 2
- ¿n¤À
- 1521
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2016-1-13
|
´£°Ý½Ð¾¨¶q´£¨Ñ¤å¥ó¡A¤è«K¸Ñ¨M°ÝÃD¡A«D¤£±o¤w¤Ö¤W¶Ç¹ÏÀÉ¡A¹ÏÀɳ£«Ü¥eªÅ¶¡¡A¤]¤£¯à¹ê»Ú¸Ñ¨M°ÝÃD¡I |
|
|
|
|
|
|
- ©«¤l
- 109
- ¥DÃD
- 22
- ºëµØ
- 0
- ¿n¤À
- 134
- ÂI¦W
- 0
- §@·~¨t²Î
- Win7
- ³nÅ骩¥»
- Office 2000
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_¥«
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2023-3-5
|
¥»©«³Ì«á¥Ñ ¦Ñ®L ©ó 2010-9-28 17:22 ½s¿è
¤w¸g¦³¥¿³W¤Æ¤§¸ê®Æªí,¦Ü¤Ö¦³¦Û°Ê¿z¿ï¥i¥Î
³Ì¨Î¤Æ¼Ò²Õ
********************************************
1.³]©w°ÊºA¼Ï¯Ã¤ÀªRªí
2.ÂùÀ»¼Ï¯Ã¤ÀªRªí,¶e¥X©ú²Ó¸ê®Æ«á
3.¤½¥q¨î¦¡ªí®æ,¤â¤u¶ñ¼g
********************************************
¤½¥q¨î¦¡ªí®æµLªk»P¸ê®Æ®w±µyªº
¥Î¨ç¼Æ¥ÎVBA¼g,¤uµ{¯Ó¤j,¥BµL®Ä²v
********************************************
¥»¤H¤£¦^µªExcel 2007ª©¥»°ÝÃD,¤¶±¤Ó¶Ã |
|
|
|
|
|
|