µù¥U
µn¿ý
º¶
½×¾Âª©³W
¸T¤î¦Cªí
»¡©ú
¦a¹Ï
¼Æ¦ì®Ñ»
¨p¤H®ø®§ (0)
¤½¦@®ø®§ (0)
½×¾Â¥ô°È (0)
¨t²Î®ø®§ (0)
¦n¤Í®ø®§ (0)
©«¤l®ø®§ (0)
³Â»¶®a±Ú°Q½×ª©ª©
»
Excel£¸¯ë°Ï
» קï±ø¥ó½d³ò
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
µo©«
[µo°Ý]
קï±ø¥ó½d³ò
home1913
µoµu®ø®§
¥[¬°¦n¤Í
home1913
·í«eÂ÷½u
UID
3480
©«¤l
22
¥DÃD
5
ºëµØ
0
¿n¤À
36
ª÷¿ú
36
ÂI¦W
0
§@·~¨t²Î
XP
³nÅ骩¥»
office 2003
¾\ŪÅv
10
¦b½u®É¶¡
9 ¤p®É
µù¥U®É¶¡
2011-2-15
³Ì«áµn¿ý
2014-6-28
¤p¾Ç¥Í
©«¤l
22
¥DÃD
5
ºëµØ
0
¿n¤À
36
ÂI¦W
0
§@·~¨t²Î
XP
³nÅ骩¥»
office 2003
¾\ŪÅv
10
µù¥U®É¶¡
2011-2-15
³Ì«áµn¿ý
2014-6-28
1
#
¸õÂà¨ì
»
˧Ǭݩ«
¥´¦L
¦rÅé¤j¤p:
t
T
µoªí©ó 2013-6-22 11:34
|
¥u¬Ý¸Ó§@ªÌ
[µo°Ý]
קï±ø¥ó½d³ò
½Ð°Ý¤U±¬õ¦r³¡¥÷n¦p¦óקï¿ï¨ú®æ¤l¤º¦³ªF¦èªº½d³ò¶Ü?
¦]¬°¨C¦¸±ø¥ó½d³ò¬Ò¤£¦P¡A¤U¦C½d³òA2~A39¡A¤£n¨C¦¸¤£¦P³£n°µ×§ï
½Ð±Ð¦U¦ì¦³¦ó¸Ñ¨M¤èªk~
Range("E1:H1").Select
Sheets("®w¦s").Columns("A").AdvancedFilter Action:=xlFilterCopy, _
CriteriaRange:=
Range("A2:A39"),
CopyToRange:=Range("E1:H1"), Unique:= _
¼Ó¥D¼ö©«
pºâÃþ§O±ø¥ó¥[Á`
¦p¦ó±N¬Û¦P±ø¥ó±a¤J¦P¤@®æ¨Ã¦Û°Ê´«¦æ
¦h±ø¥ó¶i¶¥¿z¿ï§Ö³t¤èªk
³øªí®ø±b¦©°£¼Æ¶q
¦¬ÂÃ
¤À¨É
softsadwind
µoµu®ø®§
MSN ²á¤Ñ
¥[¬°¦n¤Í
softsadwind
·í«eÂ÷½u
UID
2868
©«¤l
129
¥DÃD
3
ºëµØ
0
¿n¤À
178
ª÷¿ú
178
ÂI¦W
0
§@·~¨t²Î
XP
³nÅ骩¥»
2010
¾\ŪÅv
20
©Ê§O
¨k
¦b½u®É¶¡
93 ¤p®É
µù¥U®É¶¡
2010-12-28
³Ì«áµn¿ý
2018-11-10
¤¤¾Ç¥Í
©«¤l
129
¥DÃD
3
ºëµØ
0
¿n¤À
178
ÂI¦W
0
§@·~¨t²Î
XP
³nÅ骩¥»
2010
¾\ŪÅv
20
©Ê§O
¨k
µù¥U®É¶¡
2010-12-28
³Ì«áµn¿ý
2018-11-10
2
#
µoªí©ó 2013-6-22 12:50
|
¥u¬Ý¸Ó§@ªÌ
¦^´_
1#
home1913
Sheets("®w¦s").Columns("A").AdvancedFilter Action:=xlFilterCopy, _
CriteriaRange:=Range("A2:A39"), CopyToRange:=Range("E1:H1"), Unique:= _
§ï¦¨
Sheets("®w¦s").Columns("A").AdvancedFilter Action:=xlFilterCopy, _
CriteriaRange:=Range([A2],[A65535].End(xlUp)), CopyToRange:=Range("E1:H1"), Unique:= _
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X
TOP
home1913
µoµu®ø®§
¥[¬°¦n¤Í
home1913
·í«eÂ÷½u
UID
3480
©«¤l
22
¥DÃD
5
ºëµØ
0
¿n¤À
36
ª÷¿ú
36
ÂI¦W
0
§@·~¨t²Î
XP
³nÅ骩¥»
office 2003
¾\ŪÅv
10
¦b½u®É¶¡
9 ¤p®É
µù¥U®É¶¡
2011-2-15
³Ì«áµn¿ý
2014-6-28
¤p¾Ç¥Í
©«¤l
22
¥DÃD
5
ºëµØ
0
¿n¤À
36
ÂI¦W
0
§@·~¨t²Î
XP
³nÅ骩¥»
office 2003
¾\ŪÅv
10
µù¥U®É¶¡
2011-2-15
³Ì«áµn¿ý
2014-6-28
3
#
µoªí©ó 2013-6-22 13:18
|
¥u¬Ý¸Ó§@ªÌ
¦^´_
2#
softsadwind
·PÁ±оɡA½Ð°Ý³o¬q·N«än«ç»ò»¡©ú Range([A2],[A65535].End(xlUp)
TOP
freeffly
µoµu®ø®§
¥[¬°¦n¤Í
freeffly
·í«eÂ÷½u
UID
227
©«¤l
586
¥DÃD
123
ºëµØ
0
¿n¤À
763
ª÷¿ú
763
ÂI¦W
0
§@·~¨t²Î
WINDOW7
³nÅ骩¥»
Office 2003
¾\ŪÅv
50
©Ê§O
¨k
¦b½u®É¶¡
168 ¤p®É
µù¥U®É¶¡
2010-5-16
³Ì«áµn¿ý
2017-3-14
°ª¤¤¥Í
©«¤l
586
¥DÃD
123
ºëµØ
0
¿n¤À
763
ÂI¦W
0
§@·~¨t²Î
WINDOW7
³nÅ骩¥»
Office 2003
¾\ŪÅv
50
©Ê§O
¨k
µù¥U®É¶¡
2010-5-16
³Ì«áµn¿ý
2017-3-14
4
#
µoªí©ó 2013-6-24 14:22
|
¥u¬Ý¸Ó§@ªÌ
¦^´_
3#
home1913
§A¥Îselect³æ¿W¾Þ§@¤U±³o¤@¥y
µM«á¨C¸Õ¤@¤U¦bAÄæ·s¼W¸ê®Æ
¬Ý¬ÝÅܤÆ
Range([A2],[A65535].End(xlUp).select
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ
TOP
ÀR«ä¦Û¦b :
¤Hnª¾ºÖ¡B±¤ºÖ¡B¦A³yºÖ¡C
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
EXCEL±MÄÝ°Q½×°Ï
Excel£¸¯ë°Ï
Excelµ{¦¡°Ï
¶i¶¥À³¥Î±M°Ï
OFFICE ¨t¦C
Word
PowerPoint
Access
Office¤£¤À°Ï
µ{¦¡»y¨¥
VB »P VB.Net
C »P C#
Java »P J#
µ{¦¡³]p¤£¤À°Ï
¸ê®Æ®w
ORACLE
My SQL
MS SQL
ºô¶³]p
ASP »P ASP.NET
PHP
PHP+MySQL ¤Jªù¹ê§@
JavaScript
FLASH / ActionScript
HTM/ HTML/ CSS
ºô¶³]p¤£¤À°Ï
¹q¸£»P§@·~¨t²Î
¹q¸£¦UºØµwÅé°Q½×
¤@¯ë¹q¸£³nÅé°Q½×
½×¾Â¨Æ°È
ºÞ²z¤½§i
§ë¶D¤Ï¬M
·s¤â´ú¸Õ
·R ¡E ¥Í¬¡
¤½¯q§G§iÄæ
¥Í¬¡»P·P°Ê
[¦¬Âæ¹¥DÃD]
[Ãöª`¦¹¥DÃDªº·s¦^´_]
[³q¹L QQ¡BMSN ¤À¨Éµ¹ªB¤Í]
¥Ó½Ð¤Í±¡Ãì±µ
Facebook¯»µ·