|
Sub 条件隐藏()
Dim rng As Range
Dim i As Integer, j As Integer, m As Integer, n As Integer, k As Integer
Dim sht As Worksheet
Set sht = Worksheets("逾期或未完成的情况说明")
i = Worksheets("首页").Cells(Rows.Count, "i").End(xlUp).Row
For Each rng In Worksheets("首页").Range("i3:i" & i)
If rng.Text = "完成" Or rng.Offset(0, 6).Value = "100%" Then
rng.EntireRow.Hidden = True
Worksheets(rng.Offset(0, -8).Value).Visible = False
Else
j = Worksheets(rng.Offset(0, -8).Value).Cells(Rows.Count, 1).End(xlUp).Row
m = j - 7
For n = 1 To m
k = k + 1
sht.Range("a" & k + 2) = Worksheets(rng.Offset(0, -8).Value).Range("a" & n + 7)
sht.Range("b" & k + 2) = Worksheets(rng.Offset(0, -8).Value).Range("b" & n + 7)
sht.Range("c" & k + 2) = Worksheets(rng.Offset(0, -8).Value).Range("c" & n + 7)
sht.Range("d" & k + 2) = Worksheets(rng.Offset(0, -8).Value).Range("d" & n + 7)
sht.Range("e" & k + 2) = Worksheets(rng.Offset(0, -8).Value).Range("k" & n + 7)
sht.Range("f" & k + 2) = Worksheets(rng.Offset(0, -8).Value).Range("j" & n + 7)
sht.Range("g" & k + 2) = m
Next
m = 0
End If
Next
End Sub
|
评分
-
1
查看全部评分
-
|