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

[µo°Ý] ½Ð±Ð°ª¤â...excel¦³¿ìªk°µ¨ì¡A¦Û°Ê¡u·s¼W¡v¡u­×§ï¡v¡u§R°£¡v¶Ü??

[µo°Ý] ½Ð±Ð°ª¤â...excel¦³¿ìªk°µ¨ì¡A¦Û°Ê¡u·s¼W¡v¡u­×§ï¡v¡u§R°£¡v¶Ü??

½Ð±Ð°ª¤â...excel¦³¿ìªk°µ¨ì¡A¦Û°Ê¡u·s¼W¡v¡u­×§ï¡v¡u§R°£¡v¶Ü??
¤@­Óªí³æ¤º®e¦³¤£¦PªºÃþ§O¡A¥u­n²Ä¤@­Ó­¶ÅÒªºÃþ§O¦³¥´¤W¹ïÀ³ªº¤å¦r¤Î¥i¥H¦Û°Ê·s¼W¨ì¸Ó¹ïÀ³¤å¦rªº­¶ÅÒ
¥u­n¦b²Ä¤@­Ó­¶ÅÒ°µ·s¼W¡B­×§ï¡B§R°£¡A³£·|¦Û°Ê®M¥Î¨ì¤l­¶ÅÒ¤W(½Ð¬Ýªþ¹Ï)
³oÀ³¸Ó¬O­n¼gµ{¦¡...¦ý¬O§Ú¤£·|...
¦ÑÁó¥æ¥N³o­Ó¥\½Ò>"<¥s§Úexcel®Ñ¬Ý¤@¬Ý´N¦n¡A¦ÑÁóÁ`ı±o³o¬Oexcel¤º«Øªº¥\¯à...
½Ð°ª¤â±Ï±Ï§Ú~~~À°§Ú¼gµ{¦¡...

¬O¦³¿ìªk°Ú...

¥H¤U¬O³Ì²©ö¨Ò¤l ¦b+°j°é §Y¥i¹F¨ì±z·Q­nªº

¨Ò¦p
if  sheets("¤é³øªí").range("e2").value="«È¶D" then sheets("«È¶D").range("e2").value =  sheets("¤é³øªí").range("e2").value

end if

  ¦h°µ¦h·Q¦h¾Ç²ß¡A¤Ö¬Ý¤Ö¿ù¤Ö°g³~

  ¦h°µ=¦h¦h½m²ß¡A¦h¦h½s¼g¡C
  ¦h·Q=·Q·Q¬°¤°»ò¤H®aµ{¦¡­n¨º¼Ë¼g¡A¦pªG´«¦¨¦Û¤v¡A¤S·|«ç¼g¡C
  ¦h¾Ç²ß=¾Ç²ß¤H®aªºµo°Ý¨Ã¸Ñµª¡A¾Ç²ß¤H®aªº¼gªk

  ¤Ö¬Ý=¥u¬Ý¤£°µ¤]ªPµM

TOP

¦^´_ 1# Iuy762102896
½Ð¤W¶ÇÀɮסA¦p¦¹¤j®a³£¯àÁA¸Ñ¥B©ö©ó¨ó§U©p¡C

TOP

¥»©«³Ì«á¥Ñ Hsieh ©ó 2012-11-22 22:59 ½s¿è

¦^´_ 1# Iuy762102896
¨C­Ó¤lªí³æªºA2°}¦C¤½¦¡
=IF(COUNTIF(¸ê®Æ!$D$2:$D$5,MID(CELL("filename",$A$1),FIND("]",CELL("filename",$A$1))+1,2))+1=ROW($A1),"¥H¤UªÅ¥Õ",IF(COUNTIF(¸ê®Æ!$D$2:$D$5,MID(CELL("filename",$A$1),FIND("]",CELL("filename",$A$1))+1,2))<ROW($A1),"",OFFSET(¸ê®Æ!$A$1,SMALL(IF(¸ê®Æ!$D$2:$D$5=MID(CELL("filename",$A$1),FIND("]",CELL("filename",$A$1))+1,2),ROW($2:$5),""),ROW($A1))-1,COLUMN()-1)))
¦V¥k¦V¤U½Æ»s
¤ÀÃþ.rar (11.46 KB)
play.gif
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦n¶}¤ß³á>"<­ì¨Ó¯uªº¥i¥H°µ¨ì¡A·PÁ¦U¦ìªºÀ°¦£¡AÀɮקکñ¦b¤½¥q>"<
©ú¤Ñ¶Ç¤W¨Ó~~
¤£¹Lµ{¦¡¦³¤F¡A¦ý¬O§Úµ{¦¡­n©ñ¦b­þ¸Ì®º~~
Hsieh ¤j¤j  ¡A§AªºÀɮקڵLÅv¥i¥H¤U¸ü0.0

TOP

Hsieh ¤j¤j~§Ú¦³½Æ»s§A»¡­n©ñ¦bA2ªºµ{¦¡~~¥i¬O§Ú¤@ª½¥X²{¿ù»~~~§Ú§ä¤£¥X­ì¦]...

TOP

¦^´_ 6# Iuy762102896


    ¿ù»~°T®§ºI¹Ï¤W¨Ó§a£¾£¾

  ¦h°µ¦h·Q¦h¾Ç²ß¡A¤Ö¬Ý¤Ö¿ù¤Ö°g³~

  ¦h°µ=¦h¦h½m²ß¡A¦h¦h½s¼g¡C
  ¦h·Q=·Q·Q¬°¤°»ò¤H®aµ{¦¡­n¨º¼Ë¼g¡A¦pªG´«¦¨¦Û¤v¡A¤S·|«ç¼g¡C
  ¦h¾Ç²ß=¾Ç²ß¤H®aªºµo°Ý¨Ã¸Ñµª¡A¾Ç²ß¤H®aªº¼gªk

  ¤Ö¬Ý=¥u¬Ý¤£°µ¤]ªPµM

TOP

¦^´_ 7# mark15jill

§ÚªºÀÉ®×...¤j¤jÀ°§U§Ú§a...3QQ

¤é³øªí-½d¨Ò.rar (22.04 KB)

TOP

¦^´_ 4# Hsieh

¤j¤j¡A§Ú½Æ»s§Aªº¿é¤J...¦ý¨S¦³¿ìªk¸ò§A¤@¼Ë­C
¥Àªí³æ¬O·|¤@ª½¿é¤J¸ê®Æªº¡A¥u­n¦³¿é¤J¨Ò¦p"«È¶D"ªº¡A³£·|¦Û°Ê¶]¨ì«È¶Dªº¤lªí³æ¡A©Ò¥H¦pªG¥Àªí³æ¦³100µ§¡A¤lªí³æ¤]­n¦Û°Ê¶]¥X100µ§­C
§Aªº¤èªk¬O¤£¬O§Ú­n¦Û¤v¤â°Ê³]©w§r?¦]¬°§Ú©¹¤U½Æ»s¨ç¼Æ¡A¥X²{¤w¤UªÅ¥Õ??µM«á¤U­±³£¨SªF¦è
¥Àªí³æ¦³¨âµ§«È¶Dªº¸Ü¡AÁÙ¬O¥u·|¶]²Ä¤@µ§¹L¥h¦Ó¤w@@

¸ê®Æ.rar (8.76 KB)

TOP

¥»©«³Ì«á¥Ñ shootingstar ©ó 2012-11-25 22:00 ½s¿è

®Ú¾ÚHsiehªº¸Ñµª¡A§Ú®M¥Î¦b¦Û¤v©Ò»Ýªº³øªí¸Ì¡A¸Õ¤F«Ü¤[¡A²×©ó¦¨¥\¤F¡AÁÂÁ¡C
¦pªG¡A­n®Ú¾Ú²£«~Ãþ§O·s¼W¦b¦U¦ÛªºexcelÀɸ̡A¬O§_´N¶·ÂÇ¥ÑVBA§¹¦¨©O¡H´M¨D¸Ñµª¡AÁÂÁ¡C
¶i¶¥.rar (493.94 KB)

TOP

        ÀR«ä¦Û¦b : ¤@¥y·Å·xªº¸Ü¡A´N¹³©¹§O¤H¨­¤WÅx­»¤ô¡A¦Û¤v·|ªg¨ì¨â¤Tºw¡C
ªð¦^¦Cªí ¤W¤@¥DÃD