- ©«¤l
- 5
- ¥DÃD
- 2
- ºëµØ
- 0
- ¿n¤À
- 11
- ÂI¦W
- 0
- §@·~¨t²Î
- windows XP
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2010-5-9
- ³Ì«áµn¿ý
- 2013-4-9
|
[µo°Ý] ¹j¦C½Æ»s¸ê®Æ¦Ü¥t¤@¤u§@ªí¡A¨Ì¹ïÀ³Äæ¦ì¶K¤W
¥»©«³Ì«á¥Ñ viggostar ©ó 2010-5-24 23:56 ½s¿è
¦U¦ì°ª¤â¦n¡AªþÀɬO§Ú°µªºsampleÀÉ
detail¤u§@ªí¬°¸ê®Æ¨Ó·½
Order¤u§@ªí«h¬Oq®Æ³æ
¤º§tªº¥¨¶°»yªk¬O
±Ndetail¤u§@ªí¤¤ªº¸ê®Æ¨ÌCÄ檺¤Hû¿ï¥X¥LÁÙ¨Sq¹s¥óªº¶µ¥Ø
¨Ã±N¦UÓ§Ú»Ýnªº¸ê®Æ¤@¤@½Æ»s¨ìorder¤u§@ªíªº¹ïÀ³Äæ¦ì¤¤
§Ú¦³·Q¹L¥Î (sheet1).range("a3").value=(sheet3).range(q3).value ¤§Ãþªº¼gªk, ´N¤£»Ýnselect.copy¨º»ò¦h¦¸
¡ô¥u¬O¦L¶H¤¤°O±o³o»ò¼g, ®Ñ¤£¦b¤âÃä
¦ý¿z¿ï«áªº¸ê®Æ¨Ã¤£¬O¬Û¾Fªº¦C, ¤£ª¾¹D»yªk¸Ó«ç»ò§ï¼g
§Ú·Q°µªº¥\¯à (¦p"¦¨ªG"¤u§@ªíÅã¥Ü)
1. ¦p¤W©Ò»¡, ±Ndetail¤u§@ªí¤¤¿z¿ï¦nªº¸ê®Æ, ¨Ì¤£¦PÄæ¦ì½Æ»s¨ìorder¤u§@ªíªº¹ïÀ³Äæ¦ì¤¤
2. ½Æ»s²Ä¤GÓ¤Hªº¸ê®Æ«á, ¦Û°Ê¶K¨ì³Ì«á¤@¦C¸ê®Æªº¤U¤@¦C
·PÁ¦U¦ì°ª¤âÀ°¦£
Sample.rar (9.39 KB)
|
|