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

[µo°Ý] ¦p¦óÅý¥¨¶°¡u¦Û°Ê¡v°õ¦æ¡H

[µo°Ý] ¦p¦óÅý¥¨¶°¡u¦Û°Ê¡v°õ¦æ¡H

¦U¦ì°ª¤â­Ì¦n
¤p©f¤µ¤Ñ·Q¸ß°Ý¤@¤U¡u«Ý¿ì¨Æ¶µ¡v§Ú¦³¿ý»s¥¨¶°¡AÅý¡u§¹¦¨/¥¼§¹¦¨¡v±N¥¼§¹¦¨¤ÎªÅ¥Õ¯d¤U¡K
¦ý¥Ø«e³£¥²¶·¤â°Ê¾Þ§@¤~¥i¥H¡A­Y·Q§â¥¨¶°§ï¬°¦Û°Ê¥´¤W¡u§¹¦¨¡v«á¡A´N¤£¨£ªº¸Ü¡AÀ³¦p¦ó­×§ï¡H
ÁÂÁ°ª¤â~

¥¨¶°¤º®e¦p¤U¡G
Sub ¥¨¶°1()
'
' ¥¨¶°1 ¥¨¶°
'

'
    ActiveSheet.Range("$A$3:$H$41").AutoFilter Field:=4, Criteria1:="=¥¼§¹¦¨", _
        Operator:=xlOr, Criteria2:="="
End Sub

«Ý¿ì¨Æ¶µ.zip (19.91 KB)

        ÀR«ä¦Û¦b : ¬O«D·í±Ð¨|¡AÆg¬ü§@ĵ±§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD