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

¤£¦Pªºµ{¦¡¼gªk

¤£¦Pªºµ{¦¡¼gªk

·Q½Ð±Ð¥H¤U³o¤@¬qµ{¦¡¬O§_¦³°õ¦æ°_¨Ó¤ñ¸û§Öªº¼gªk ?
§Ú¥u¬O·Q°Ñ¦Ò¬Ý¬Ý¤£¦Pªºµ{¦¡¼gªk.
·PÁÂ...
  For fcsty = 4 To put_rownum
            If .Cells(fcsty, "B") <> "" And Not .Cells(fcsty, "A") Like "*¦X­p" Then
               ' ¼W¥[§PÂ_ "B"Ä欰ªÅ¥Õ, ©Î¬O«O¯d "¦X­p" ªº¦C.
                If .Cells(fcsty, hid_colnum) < put_maxnum And .Cells(fcsty, hid_colnum) > put_minnum Then
                    .Rows(fcsty).Hidden = True
                End If
            End If
        Next
    End With


_________________________________________
¾ã¬qµ{¦¡
Sub ProductsQ1FP()
ActiveSheet.PivotTables("¼Ï¯Ã¤ÀªRªí1").PivotFields("Group").ClearAllFilters
ActiveWindow.FreezePanes = False ' ¨ú®ø­áµ²µøµ¡
Dim put_rownum As Integer
Dim hid_colnum As Integer
ActiveSheet.Rows.Hidden = False '¨ú®ø©Ò¦³ªºÁôÂÃ
ActiveSheet.Range("c4").Select  '´å¼Ð©ñ¦bc4
ActiveWindow.FreezePanes = True '­áµ²µøµ¡
ActiveWindow.ScrollColumn = 3   '­áµ²¦C»PÄ檺µøµ¡
ActiveSheet.PivotTables("¼Ï¯Ã¤ÀªRªí1").PivotFields("Group").AutoSort xlDescending, _
    "¥[Á` ªºQ1F-P"
put_rownum = ActiveSheet.Range("c2").Value  '³Ì«á¤@¦C
put_maxnum = ActiveSheet.Range("b1").Value  '¤j©ó
put_minnum = ActiveSheet.Range("b2").Value  '¤p©ó
hid_colnum = ActiveSheet.Range("f1").Value  '±Æ§ÇÄæ
With ActiveSheet
        .Cells(4, hid_colnum).Select            '´å¼Ð©ñ¸mÂI
        For fcsty = 4 To put_rownum
            If .Cells(fcsty, "B") <> "" And Not .Cells(fcsty, "A") Like "*¦X­p" Then
               ' ¼W¥[§PÂ_ "B"Ä欰ªÅ¥Õ, ©Î¬O«O¯d "¦X­p" ªº¦C.
                If .Cells(fcsty, hid_colnum) < put_maxnum And .Cells(fcsty, hid_colnum) > put_minnum Then
                    .Rows(fcsty).Hidden = True
                End If
            End If
        Next
    End With
End Sub
fangac

¥»©«³Ì«á¥Ñ GBKEE ©ó 2012-6-17 13:38 ½s¿è

¦^´_ 2# register313


    °õ¦æ¦³¤@¨Ç°ÝÃD.
¬O¤£¬O»Ý­n«Å§iRngÅܼÆ, ¦ý§Ú¥[¤J¤FRngÅܼƫŧi,¤]µL®Ä.
·q½Ð«üÂI. ÁÂÁÂ.

Sales by Org.rar (875.75 KB)

fangac

TOP

·PÁ¤G¦ì«ü¾É.
µ{¦¡¬Ý¤£¤ÓÀ´,°ò¥»¥\ÁÙ¬O»Ý­n¦h½m²ß,¦n¦n²z¸Ñ¤@¤U,¥i¥HÀ³¥Î¦b§Oªº¦a¤è.
fangac

TOP

        ÀR«ä¦Û¦b : ¨ü¤HÂI¤ô¤§®¦¡A¶··í´é¬u¥H³ø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD