¤£¦n·N«ä ·s¤â¤S¨Ó½Ð±Ð ¸ê®Æ¤ñ¹ï°ÝÃD ³Â·Ð¦U¦ì¤F
- ©«¤l
- 26
- ¥DÃD
- 6
- ºëµØ
- 0
- ¿n¤À
- 33
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- OFFICE2003
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-7-19
- ³Ì«áµn¿ý
- 2013-5-13
|
ªO¤j§A¦n~adef ¥u¬O§Ú°²³]¦³¨ä¥LªºÄæ¦ì¤w¸g¦bbook1¸Ì±,¦bbook1¤¤¥Dn¬O¥h¬Ýope_no ¸òpart_id ³o¨âÓÀx¦s®æ¥k¤âÃ䪺¸ê®Æ(parit-id---->12345, ope_no ---> 333 444 555 777),³o¨Ç¸ê®Æ¬O±qbook2¸Ì±ªºb sheet¨Óªº,¥u¬O¦bbook2 copy¹L¨Ó¤§«á ¦bbook1n°µ¤@¨Çקï ,ope_no ´N¬OnÅܬ° ('333','444','555','777')¥[¤W¬A©·,³r¸¹©M¤À¸¹
partid «h¬O¦pªG¦bbook2¸Ì±¦³¤@Ó¥H¤Wªºpart_id¥X²{®É ,¦b¶ñ¤Jbook1ªº®É«á,nÅܦ¨ part id 12345 5678 (5678n¶ñ¦b12345®ÇÃ䨺ÓÀx¦s®æ)
¤£ª¾¹D³o¼Ë¦³²M·¡¶Ü? ÁÂÁ§A §Ú¤]·|¦Û¤v¦b¸ÕµÛ¼g~ |
|
|
|
|
|
|
- ©«¤l
- 26
- ¥DÃD
- 6
- ºëµØ
- 0
- ¿n¤À
- 33
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- OFFICE2003
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-7-19
- ³Ì«áµn¿ý
- 2013-5-13
|
½Ð°ÝªO¤j ¤£¦n·N«ä ¦A½Ð±Ð¤@Ó°ÝÃD ³o¼Ëªº»Ý¨D§Ú¥i¥H°Ñ¦Ò®ÑÄy¤¤ªºþ¨Çfunction ? ÁÂÁ |
|
|
|
|
|
|
- ©«¤l
- 26
- ¥DÃD
- 6
- ºëµØ
- 0
- ¿n¤À
- 33
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- OFFICE2003
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-7-19
- ³Ì«áµn¿ý
- 2013-5-13
|
vba ¤ñ¹ï¸ê®Æ°ÝÃD
¤£¦n·N«ä ¤p§Ì³o°ÝÃD¤w¸g§xÂZ«Ü¤[ ¹ê¦b·Q¤£¥X¨Ó ©Ò¥H¤W¨Ó¨D±Ï ,ÁÂÁ¤j®a¼·®É¶¡À°§Ú¬Ý
¦³¨âÓexcelÀÉ,¦pªþ¥ó
book1¸Ì±ªºc sheet ¬O§Ú·Qn«Ø¥ß¤@Óbuttonªº¦a¤è,«ö¤U¥h¤§«á¯à°÷°µ¥H¤U°Ê§@
¥Øªº¬O§Æ±æ¯à°÷§âbook2 (b sheet) ¸Ì±ªº¸ê®Æ §ì¨ìbook1ªº (a sheet ),
¤]´N¬O§âÃC¦â¼Ð¥X¨Óªº¦a¤èbook2.b.sheet,COPY¨ìbook1.a.sheet
ªþÀɪºÃC¦â¬O§Ú«á¨Ó¥[¤W¥hªº,¥u¬O¬°¤F¤è«K´yz ,
part_id ¶ñ§¹¤F©¹¥kÃäÀx¦s®æshift¤@¦ì ¨Ì¦¹Ãþ±À,
ope_no¥u»Ý§ì«á¤T½X «e«á»Ýn©T©w¥Î(),¥Î,¸¹¹j¶},¨CӼƦr³£n¦³ ' '
¤º®e¤w¸g²¤Æ,¹ê»Ú¤Wªºtable¸ê®ÆÆZ¦h,¤£³æ¥u¬O¨âµ§, §Ú»{¬°n¥Îfor°j°é ¦ýÁÙ«Ü¹à ¤£¤Ó¼ô ½Ð±Ð¦U¦ì¤F
¥H¤W ·P¿E¤£ºÉ
question.rar (4.6 KB)
|
|
|
|
|
|
|