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

½Ð°ÝÃö©óGBKEE ¤j¤j©Ò¦^ÂЪº¶i¶¥¿z¿ï°ÝÃD

½Ð°ÝÃö©óGBKEE ¤j¤j©Ò¦^ÂЪº¶i¶¥¿z¿ï°ÝÃD

¤Þ¥Î

¤Þ¥Î¤¤ GBKEE ¤j¤j ©Ò¦^ÂÐ
Sub Ex()
Sheets("Sheet3").[A1].CurrentRegion = ""
Sheets("¸ê®Æªí").Range("A1").CurrentRegion.AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=Sheets("ªí®æ").[K1:L2], CopyToRange:=Sheets("Sheet3").[A1]
End Sub
³o¬O©Ò¦³ªº¸ê®Æ
¦pªG­n§ï¦¨¿z¿ï¥X ¤£¿ï­«½Æªº¬ö¿ý ­n¦p¦ó°µ©O
¦³¤H¥i¥H«ü¾É«ü¾É¤p§Ì¶Ü
·PÁÂ~~~

¥»©«³Ì«á¥Ñ linshin1999 ©ó 2011-1-7 19:29 ½s¿è

1)§Úı±o§A¥i¥H°Ñ¦Ò Hsieh ª©¥D©Ò¼gªº Dictionary ªº¨Ï¥Î¤è¦¡,ºô§}¦p¤U:

http://forum.twbts.com/viewthread.php?tid=20&from=favorites


2)¥H¤U³o¬q¤]«Üºë±m:


http://forum.twbts.com/viewthrea ... %AB%BD%C6%B2M%B3%E6
V98

TOP

¦^´_ 1# gn00487767


    ¾ÇµÛ¥Î¿ý»s¥¨¶°¨ú±o°ò¥»µ{¦¡½X¡A°t¦XF1»¡©ú
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 2# linshin1999


    ·PÁ linshin1999 ¤j¤jµ¹§Úªº°T®§¸ê®Æ
    ¤p§Ì¦A¥h°Ñ¦Ò°Ñ¦Ò

TOP

¦^´_ 3# Hsieh


¦A¦¸·PÁ Hsieh ¤j¤j¤£¹½¨ä·Ðªº«ü¾É
­ì¨Ó¥i¥H¥Î¿ý»s¥¨¶°¥h°Ñ¦Òµ{¦¡½X
¤p§Ì¤F¸Ñ¤F ³o¹ï¤p§ÌªºÀ°§U«D±`¤j©O
Åý¤p§Ì¾Ç²ß¹Lµ{¤¤¤S¦³¤F¤@­Ó¶¥¬qªº¤É¯Å¤F
¤p§Ì·|¸ÕµÛ¦Û¦æ¬ã¨s¬ã¨s

TOP

        ÀR«ä¦Û¦b : ¦³Ä@©ñ¦b¤ß¸Ì¡A¨S¦³¨­Åé¤O¦æ¡A¥¿¦p¯Ñ¥Ð¤£¼½ºØ¡A¬Ò¬OªÅ¹L¦]½t¡C
ªð¦^¦Cªí ¤W¤@¥DÃD