- ©«¤l
- 8
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 14
- ÂI¦W
- 0
- §@·~¨t²Î
- WINDOW XP
- ³nÅ骩¥»
- OFFICE 2007
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- ¨Ó¦Û
- TAIWAN
- µù¥U®É¶¡
- 2012-12-25
- ³Ì«áµn¿ý
- 2012-12-26
|
[¤À¨É] ¸Ñ¨M Åã¥Ü"¨t²Î¸ê·½¤£¨¬¡AµLªk§¹¾ãÅã¥Ü°ÝÃD" (³æ¤@±¡ªp)
¤j®a¦n~
¥ý«eÀ°¤½¥q¼g¤F¤@Óexcel vba µ{¦¡¡A¨ä°ò¥»¬[ºc¬°¡G
sheet1¡G¥u©ñª«¥ó¡F´£¨ÑUI
sheet2¡GÀx¦s®æ¤¤¥u©ñsheet1©Ò»Ýªº¸ê®Æ
µ²ªG¡G
1¡B¦bsheet2¤£¬O100%À˵ø¤j¤pªº±¡ªp¤U¡Asheet1 ¤£¯à°÷§ïÅÜÀ˵ø¤j¤p¡C(¾Þ§@ª«¥ó·|Åã¥Ü¨t²Î¸ê·½¤£¨¬¡AµLªk§¹¾ãÅã¥Ü)
2¡B¦bworksheet¤¤¼g¤Jvba code¡A¨Ï¨C¦¸¶}Àɳ£·|±j¨îsheet2¬°À˵ø100%¨ÃÁôÂáA¥H§Qsheet1¥i¥H§ïÅÜÀ˵ø¤j¤p¡A¦ý«o³ssheet1¤]·|¤@¨Ö¦b¶}Àɮɱj¨î³Q³]¬°À˵ø100%
µ²½×¡G
Áö¤£ª¾¹D¬°¦ó·|¦³¦¹±¡§Î¡A¦ý¸Ñ¨M(¨ä¹ê¬OÁקK)¤Fsheet1¥ô·N§ïÅÜÀ˵ø¤j¤p®É¡Aµo¥Í"¨t²Î¸ê·½¤£¨¬¡AµLªk§¹¾ãÅã¥Ü"ªº°ÝÃD¡A´£¨Ñµ¹¤j®a§@°Ñ¦Ò¡C(ª¬ªp¤À¨É)
ÁÂÁ¤j®a |
|