|
- Sub tt()
- Dim xrng As Range
- [a5:h40] = ""
- [a5:h40].Interior.ColorIndex = 0
- yf = [H2]
- minday = DateSerial(Year(Date), yf, 1)
- maxday = DateSerial(Year(Date), yf + 1, 0)
- For rq = minday To maxday
- n = n + 1
- Cells(n + 4, 1) = rq
- Next
-
- Dim k(1 To 3)
- For i = 5 To n + 4 '找到日期,标色,填入内容
- Set xrng = [N:O].Find(Cells(i, 1))
- If Not xrng Is Nothing Then
- c = xrng.Column
- xc = IIf(c = 14, 3, 6)
- Cells(i, 1).Resize(1, 8).Interior.ColorIndex = xc '找到日期,标色
- For j = 1 To 3 '填入内容
- k(j) = k(j) + 2
- k1 = k(j) + 1: k2 = k(j) + 2
- r = Cells(65536, j + 15).End(3).Row
- If k1 > r Then
- k1 = 3: k(j) = 0: k2 = 4
- ElseIf k2 > r Then
- k2 = 3: k(j) = 0
- End If
- Cells(i, j + 5) = Cells(k1, j + 15) & Chr(10) & Cells(k2, j + 15)
- Next
- End If
- Next
- End Sub
复制代码 |
|