¦p¦ó¦bVBA¤¤¼g¤JEXCEL¤½¦¡¡H
- ©«¤l
- 51
- ¥DÃD
- 17
- ºëµØ
- 0
- ¿n¤À
- 200
- ÂI¦W
- 0
- §@·~¨t²Î
- winxp
- ³nÅ骩¥»
- officexp
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-7-31
- ³Ì«áµn¿ý
- 2018-9-19
|
¦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
|
|
|
|
|
- ©«¤l
- 92
- ¥DÃD
- 18
- ºëµØ
- 0
- ¿n¤À
- 195
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-8-15
- ³Ì«áµn¿ý
- 2011-8-11
|
Sheet2.Cell(x,"A")="=VLOOKUP(A" & X & ",DDE!A:M,3,FALSE)"
Hsieh µoªí©ó 2010-8-18 18:36
µ¥¸¹¨âÃä³£¬OSheet2!A¡A¤£¬O·|³y¦¨´`Àô°Ñ·Ó?! |
|
|
|
|
|
|
- ©«¤l
- 472
- ¥DÃD
- 5
- ºëµØ
- 0
- ¿n¤À
- 485
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows
- ³nÅ骩¥»
- MS Office
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- »´ä
- µù¥U®É¶¡
- 2010-7-4
- ³Ì«áµn¿ý
- 2014-12-28
|
¦^´_ 3# solely
·|ªº, À³¸Ó¬O¼Ó¥D¦Û¦æ¸Ñ¨M«á¨S¦^¨Ó¤F |
|
|
|
|
|
|
- ©«¤l
- 51
- ¥DÃD
- 17
- ºëµØ
- 0
- ¿n¤À
- 200
- ÂI¦W
- 0
- §@·~¨t²Î
- winxp
- ³nÅ骩¥»
- officexp
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-7-31
- ³Ì«áµn¿ý
- 2018-9-19
|
¥»©«³Ì«á¥Ñ 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
|
|
|
|
|
- ©«¤l
- 4901
- ¥DÃD
- 44
- ºëµØ
- 24
- ¿n¤À
- 4916
- ÂI¦W
- 259
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- Office 20xx
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-4-30
- ³Ì«áµn¿ý
- 2024-11-30
|
¥»©«³Ì«á¥Ñ 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°Ý
|
|
|
|
|