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

¦p¦ó¦bVBA¤¤¼g¤JEXCEL¤½¦¡¡H

¦p¦ó¦bVBA¤¤¼g¤JEXCEL¤½¦¡¡H

¦pÃD¡A§Ú·Q§Q¥ÎVBA¦bÀx¦s®æ¤¤¼g¤J¤½¦¡¡A¦p=VLOOKUP(A3,SHEET1!A:M,3,FALSE)
¦ý¥Ñ©óA3¤¤ªº3¡A·Q¥HÅܼƥN¤J
©Ò¥H§Ú¬O³o¼Ë¼gªº¡G
Do while CONDITION1
¡@¡@Sheet2.Cell(x,"A")="=VLOOKUP(A" & X & ",DDE!A:M,3,FALSE)"
loop
µ²ªG°»¿ù«o»¡¥²¶·¬O³¯­z¦¡µ²§À¡A½Ð°Ý«ç»ò¼g¤ñ¸û¦n¡H½Ð¥ý¶i«üÂI¤@¤G~·PÁÂ
¤£¶i«h°h

Sheet2.Cell(x,"A")="=VLOOKUP(A" & X & ",DDE!A:M,3,FALSE)"
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

Sheet2.Cell(x,"A")="=VLOOKUP(A" & X & ",DDE!A:M,3,FALSE)"
Hsieh µoªí©ó 2010-8-18 18:36


µ¥¸¹¨âÃä³£¬OSheet2!A¡A¤£¬O·|³y¦¨´`Àô°Ñ·Ó?!

TOP

¦^´_ 3# solely


    ·|ªº, À³¸Ó¬O¼Ó¥D¦Û¦æ¸Ñ¨M«á¨S¦^¨Ó¤F
À´±oµo°Ý,µª®×´N·|¦b¨ä¤¤

¤µ¤éの¤@¬íは  ©ú¤éにない
http://kimbalko-chi.blogspot.com
http://kimbalko.blogspot.com

TOP

¦^´_ 3# solely
¨º´N¬Ý§Aªº¤½¦¡¨ì©³¬O­n°µ«ç¼Ë°Ñ·Ó
³o¥u°w¹ï§A»yªk¿ù»~°µ¸Ñµª
§AªºA2¤½¦¡¬O­n°Ñ·ÓA?
?¬O§A­nª¾¹DªºÅܼƱa¤J
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥»©«³Ì«á¥Ñ mnsmrtl ©ó 2010-8-18 22:33 ½s¿è

¤£ª¾¹D¬O¤£¬O¤£¯à¥´¤Óªø¡K
.Cells(x,4)="=if(vlookup(A" & x & ",DDE!$A: $M,4,false)=vlookup(A" & x & ",DDE!$A: $M,9,false),"¤£¯}",
(vlookup(A" & x & ",DDE!$A: $M,9,false)/vlookup(A" & x & ",DDE!$A: $M,3,false)-1)*100"
§Ú¬O¼g¦¨³o¼Ë¡A¥¦¦^ÂаT®§¬O¡u½sö¿ù»~¡A¥²¶·¬O³¯­z¦¡µ²§À¡v¡A¦pªGª½±µkey¦bÀx¦s®æÀ³¸Ó¬O¡G
=if(vlookup(a3,DDE!$A: $M,4,false)=vlookup(A3,DDE!$A: $M,9,false),"¤£¯}",
(vlookup(A3 ,DDE!$A: $M,9,false)/vlookup(A3,DDE!$A: $M,3,false)-1)*100)
¤Ï¥Õªº¦a¤è¦b¡u"¤£¯}"¡v³o¸Ì¡K
¤£ª¾¹D¬O¤½¦¡¥»¨­¦³¿ù¡AÁÙ¬O¦bvba¼gªº®É­Ô§Ë¿ù¤F¡K

·PÁ¦U¦ìÀ°¦£¡A¤p§Ì¤w¸g§ä¨ì°ÝÃD¤F¡A¦b¡u"¤£¯}"¡v³B¥²¶·¥Î""¤£¯}""¤~¦æ¡A¤w¸g¸Ñ¨M¤F^^~¤£³Ó·P¿E^^
¤£¶i«h°h

TOP

¥»©«³Ì«á¥Ñ Hsieh ©ó 2010-8-18 23:37 ½s¿è

¦^´_ 6# mnsmrtl


    ¿ý»s¤@­Ó¦³¥]§t"ªº¤½¦¡´Nª¾¹D°ÝÃD¥X¦b­þ¸Ì¤F
"=if(vlookup(A" & x & ",DDE!$A: $M,4,false)=vlookup(A" & x & ",DDE!$A: $M,9,false),""¤£¯}"",(vlookup(A" & x & ",DDE!$A: $M,9,false)/vlookup(A" & x & ",DDE!$A: $M,3,false)-1)*100"
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡µLªk¾B¾×¡j©È®É¶¡®ø³u¡Aªá¤F³\¦h¤ß¦å¡A·QºÉ¦U¦¡¤èªk­n¾B¾×®É¶¡¡Aµ²ªG¬O¡G®ö¶O¤F§ó¦h®É¶¡¡A¥B¤@µL©Ò¦¨¡I
ªð¦^¦Cªí ¤W¤@¥DÃD