Sub 按问题查询()
ends = Sheet1.Columns(1).Find("*", , , , , searchdirection:=xlPrevious).Row '动态找到A列的最后一个单元格
Sheet2.Range("A5:E1048576").Clear '清除之前所有的筛选结果
For Each Rng In Sheet1.Range("C2:C" & ends)
m = m + 1
If Rng Like Sheet2.Range("B3") Then '如果条件成立,那么
k = k + 1
Sheet1.Range("a" & m + 1 & ":E" & m + 1).Copy Sheet2.Range("a" & k + 4) '将记录复制到另一个区域
Sheet2.Range("D" & k + 4).Formula = "=sum(Sheet1!F" & m + 1 & ",Sheet1!G" & m + 1 & ")"
End If
Next
End Sub
Sub 按问题查询()
ends = Sheet1.Columns(1).Find("*", , , , , searchdirection:=xlPrevious).Row '动态找到A列的最后一个单元格
Sheet2.Range("A5:E1048576").Clear '清除之前所有的筛选结果
For Each Rng In Sheet1.Range("C2:C" & ends)
m = m + 1
If Rng Like Sheet2.Range("B3") Then '如果条件成立,那么
k = k + 1
Sheet2.Range("a" & k + 4).resize(1,5).value=Sheet1.Range("a" & m + 1).resize(1,5).value
End If
Next
End Sub
Sub 按问题查询()
Ends = Sheet1.Cells(Rows.Count, 1).End(xlUp).Row '动态找到A列的最后一个单元格
Sheet2.Range("A1").CurrentRegion.Offset(4).Clear '清除之前所有的筛选结果
M = 2
K = 5
For Each Rng In Sheet1.Range("C2:C" & Ends)
If Rng Like Sheet2.Range("B3") Then '如果条件成立,那么
Sheet1.Range("A" & M & ":E" & M).Copy Sheet2.Range("A" & K) '将记录复制到另一个区域
Sheet2.Range("D" & K).Formula = "=Sum(Sheet1!F" & M & ",Sheet1!G" & M & ")"
K = K + 1
End If
M = M + 1
Next
End Sub
Sub 按问题查询1()
Ends = Sheet1.Cells(Rows.Count, 1).End(xlUp).Row '动态找到A列的最后一个单元格
Sheet2.Range("A1").CurrentRegion.Offset(4).Clear '清除之前所有的筛选结果
M = 2
K = 5
For Each Rng In Sheet1.Range("C2:C" & Ends)
If Rng Like Sheet2.Range("B3") Then '如果条件成立,那么
Sheet2.Range("A" & K).Resize(1, 5).Value = Sheet1.Range("A" & M).Resize(1, 5).Value
K = K + 1
End If
M = M + 1
Next
End Sub