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

[µo°Ý] (ºô¸ô¤W¬Ý¨ì) ¦bEXCEL¿é¤J©m¦W«á¡A·|¦Û°Ê¿z¿ï¥X¸ê®Æ

[µo°Ý] (ºô¸ô¤W¬Ý¨ì) ¦bEXCEL¿é¤J©m¦W«á¡A·|¦Û°Ê¿z¿ï¥X¸ê®Æ

¦U¦ì«e½ú¦n

ªñ´Á¦bºô¸ô¤W¦³¬Ý¨ì¡A¦bEXCEL¿é¤J©m¦W«á¡A·|¦Û°Ê¿z¿ï¥X¸ê®Æ
¹ê¦b¬O«Ü¹ê¥Î¡A¦ý¥i±¤VBAµ{¦¡³Q¥[±K¤F

¤£¾å±o¦³¨S¦³¤H·|¼g³o¬qµ{¦¡¡A¤À¨Éµ¹¤p§Ì¾Ç²ß
¬ÛÃöÀɮצpªþ¥ó

¸U¤À·PÁÂ~~~

¦Û°Ê¿z¿ï¥X¸ê®Æ.rar (40.66 KB)

for i = 2 to range("A1").end(xldown).row

    if cells(i,"B") <> cells(1,F )  and  cells(i,"B") <>""   then Rows(i).EntireRow.Hidden = True
    if cells(i,"B") =""   then Rows(i).EntireRow.Hidden = False

next

TOP

        ÀR«ä¦Û¦b : °µ¸Ó°µªº¨Æ¬O´¼¼z¡A°µ¤£¸Ó°µªº¨Æ¬O·Mè¡C
ªð¦^¦Cªí ¤W¤@¥DÃD