ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ¦³µL¿ìªkexcel¹J¨ì®æ¤l¤º¦³¤å¦r´N¸õ¤U®æ©O¡H

[µo°Ý] ¦³µL¿ìªkexcel¹J¨ì®æ¤l¤º¦³¤å¦r´N¸õ¤U®æ©O¡H

¦U¦ì¤j¤j¦n¡G
¦³¨â±iexcel¤u§@ªí¡A²Ä¤@±i¬O«È¤á­qÁʸê®Æ¬O¦C¦L¤§«á¤£¦sÀÉ¡A²Ä¤G±i¬O©Ò¦³«È¤áªº­qÁʸê®Æ¡A³o¼Ë§Ú¥²¶·­nkey¨â¦¸¡A
¦³¨S¦³¿ìªkª½±µ¦b²Ä¤@±ikey§¹«á¸õ¨ì²Ä¤G±i©O¡H¦Ó¥B­n·Ó¶¶§Ç©¹¤U±Æ¦C¡I
¬O§_¥i¥H¥Îmsn¸ò§Ú»¡©ú©O¡H
ÁÙ¦³³o­Ó°ÝÃD¬O¶K¦b³oª©¶Ü¡H¦p¶K¿ù¦b³Â·Ð§iª¾¡AÁÂÁ¡I

³o°ÝÃDÀ³¸Ó¬O¥ÎVBAªº¤è¦¡¨Ó¸Ñ´N¥i¥H¡A©Ò¥H¨ìvba¤@¯ë°Ï°Q½×§a
½ñ¨¬¤ù¨è¡A¨É¨ü¥Í¬¡(Y)
¾K¥Í¹Ú¦º¡A´ýµM§Ñ§Ú(N)
(Y/N)?

TOP

¨Ï¥Î§»«öÁä¡A§ânew order¦Û°Ê¶ñ¤JÁ`ªí

New Order§».rar (15.05 KB)

¨C¦¸key§¹new order¤§«á¡Aclick "new order"«öÁä¡AÁ`ªí´N¼W¥[¤F·sªºorder
order ©Ò¦bªºªí¡A§Ú¥[¤F«OÅ@¡A¥u¤¹³\³W©wªºcell¿é¤J¼Æ¾Ú¡C¥t¥~orderªíªº³Ì¤U­±´X¦æ¬Oreference§@¥Îªº¡A¦pªG§A­n¥´¦L¡A¥i¥H¥´¥¦ÁôÂäF¡A¤£¼vÅT§»«öÁ䪺¾Þ§@¡C
¥i¬O¦³¤@­Ó°ÝÃD¡AÁöµM§Ú¦bÁ`ªí³]¸m¤FÁקK­«½Æ¿ý¤Jªº¼Æ¾Ú¦³®Ä©Ê³]¸m¦bpurchase #Äæ¡A¦ý¬O¹ï©óvalue paste¤£°_§@¥Î¡A©Ò¥H§A­n¤p¤ß¡A¥u«ö¤@¦¸´N¦n¤F¡C
§Ú³ß欢 excel

TOP

³o°ÝÃDÀ³¸Ó¬O¥ÎVBAªº¤è¦¡¨Ó¸Ñ´N¥i¥H¡A©Ò¥H¨ìvba¤@¯ë°Ï°Q½×§a
zcxzcxz µoªí©ó 2011-8-12 13:22



    ¤£¥ÎVBA³o»ò½ÆÂøªº¡A§Ú°µªºnew order §» «öÁä¨BÆJ¦p¤U¡G
developer-->code--->record Macro----->select sheet1! $A$24:$G$25---->select sheet2! A1---->CTRL+arrow down----->paste value----->stop recording

µM«á¦AÁä¤@­Ó«öÁä¡A§â§»«ü©wµ¹³o­Ó«öÁä
§Ú³ß欢 excel

TOP

¦^´_ 3# zeny


    ¤£¦n·N«ä,§ÚµLªk¤U¸üªþ¥ó,¬O§_¥i¥H±Hµ¹§Ú,©Î¶Çmsnµ¹§Ú©O¡H¨º§ÚÁÙ¦³¨ä¥¦ªº°ÝÃD¬O§_¥i¥H¤@¨Ö°Ý§A©O¡HÁÂÁÂ

TOP

        ÀR«ä¦Û¦b : §g¤l¥ß«í§Ó¡A¤p¤H«í¥ß§Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD