½Ð°Ý¤@ӱƧÇÂà¸m¡]VBA¡^ªº°ÝÃD
- ©«¤l
- 102
- ¥DÃD
- 30
- ºëµØ
- 0
- ¿n¤À
- 137
- ÂI¦W
- 0
- §@·~¨t²Î
- winxp
- ³nÅ骩¥»
- 12
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-11-24
- ³Ì«áµn¿ý
- 2018-12-6
|
½Ð°Ý¤@ӱƧÇÂà¸m¡]VBA¡^ªº°ÝÃD
1.±q¸ê®ÆÀÉ(a1~a6)Âà¸m¦¨¿é¥XÀÉ(c1~c6)
2.¨Ò¦p¿é¥XÀɱqc1¹ïÀ³a1®É¡A¦^¥h´M§ä¸ê®ÆÀɹïÀ³Äæ¦ìµ¥©óa1b1¡A¦A¹ïÀ³¸ê®Æ®wªºÈ12¡AµM«áÅã¥Ü©óK7Äæ
3.¦bIÄæ²Îp¦U¦CȪºÁ`©M |
|
|
|
|
|
|
- ©«¤l
- 102
- ¥DÃD
- 30
- ºëµØ
- 0
- ¿n¤À
- 137
- ÂI¦W
- 0
- §@·~¨t²Î
- winxp
- ³nÅ骩¥»
- 12
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-11-24
- ³Ì«áµn¿ý
- 2018-12-6
|
¦^´_ 2# register313
½Ð°Ý¤§«e°Ñ¦Ò±zªºµ{¦¡¡Aµo²{¦n¹³¦pªG¥X²{«½Æ´NµLªk±Æ¡An¦p¦ó³B²z©O¡H
1.½Ð°Ý¦pªGn±q¸ê®ÆÀɤ¤ ¡A¥ý±qa1¡]c1,c1,c1,c1¡^¶¶§Ç¤U¨Ó¡A¦A¨Ó±Æa2±a¤J¿é¥XÀÉ
2.«½Æªº¤]¥i±Æ
3.vlookup¦pªG§ì¤£¨ìÈ¡A¥i¥H±a¤J0¶Ü |
|
Tony
|
|
|
|
|