Sub 统计()Dim i, k, l, m As IntegerFor i = 2 To Sheets.Count k = k + Application.WorksheetFunction.CountA(Sheets(i).Range("a:a")) - 1 l = l + Application.WorksheetFunction.CountIf(Sheets(i).Range("f:f"), "男") m = m + Application.WorksheetFunction.CountIf(Sheets(i).Range("f:f"), "女")NextSheet1.Range("d26") = kSheet1.Range("d27") = lSheet1.Range("d28") = mEnd Sub
Sub 查询()On Error Resume NextSheet1.Range("d14").ClearContentsFor i = 2 To Sheets.Count Sheet1.Range("d14") = Application.WorksheetFunction.VLookup(Sheet1.Range("d9"), Sheets(i).Range("a:h"), 5, 0) Sheet1.Range("d16") = Application.WorksheetFunction.VLookup(Sheet1.Range("d9"), Sheets(i).Range("a:h"), 6, 0) Sheet1.Range("d18") = Application.WorksheetFunction.VLookup(Sheet1.Range("d9"), Sheets(i).Range("a:h"), 3, 0) Sheet1.Range("d20") = Application.WorksheetFunction.VLookup(Sheet1.Range("d9"), Sheets(i).Range("a:h"), 8, 0) Sheet1.Range("d22") = Sheets(i).Name If Sheet1.Range("d14") <> "" Then Exit For End IfNextEnd Sub