|
楼主 |
发表于 2023-3-7 16:05
|
显示全部楼层
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
老师以下是源码数据在一表,统计在二表获取动态列一表的数据
Sub 定位()
Dim y2%, y1%, m%, n%, x As Long, 定位 As Byte
定位 = [C1]'动态定列
Worksheets("Sheet3").Range("C5:R20") = ""
Application.ScreenUpdating = False
x = Worksheets("Sheet1").Range("A1").Value
For ia = 1 To 16
For i = 4 To x - 1
y1 = Worksheets("Sheet1").Range("F" & i).Value '需要修改此处
y2 = Worksheets("Sheet1").Range("F" & (i + 1)).Value '需要修改此处
If y1 = ia Then
n = 4 + Application.WorksheetFunction.Match(y1, Worksheets("Sheet3").Range(Worksheets("Sheet3").Cells(5, 2),
Worksheets("Sheet3").Cells(20, 2)))
m = 2 + Application.WorksheetFunction.Match(y2, Worksheets("Sheet3").Range(Worksheets("Sheet3").Cells(3, 3),
Worksheets("Sheet3").Cells(3, 18)))
Worksheets("Sheet3").Cells(n, m).Value = Worksheets("Sheet3").Cells(n, m).Value + 1
End If
Next i
Next ia
Application.ScreenUpdating = True
End Sub |
|