|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
- Sub Query()
- Dim vntD, lngC As Long, I, J, K, strDate As String, vntR()
- lngC = Sheets("每日公司汇总").UsedRange.Rows.Count - 4
- vntD = Sheets("每日公司汇总").Range("a4").Resize(lngC, 12)
- strDate = Sheets("个人每日明细").Range("A1").Value
- For I = 1 To lngC
- If vntD(I, 1) = strDate Then
- ReDim Preserve vntR(9, K)
- vntR(0, K) = vntD(I, 2)
- For J = 1 To 9
- vntR(J, K) = vntD(I, J + 3)
- Next
- K = K + 1
- End If
- Next
- Sheets("个人每日明细").Range("A24").Resize(K, 10) = Application.WorksheetFunction.Transpose(vntR)
- End Sub
复制代码 |
|