我这简易一点
Sub 生成图纸目录()
D = InputBox("请输入日期", "日期输入", "2013/3/8")
ARR = Sheets("28FEB13 ").Range("C3:S" & Sheets("28FEB13 ").Range("C65536").End(3).Row)
ReDim BRR(1 To UBound(ARR), 1 To 9)
DT = DateValue(D)
For I = 1 To UBound(ARR)
If ARR(I, 17) = DT Then
T = T + 1
BRR(T, 1) = T
BRR(T, 3) = ARR(I, 4)
BRR(T, 5) = "A3"
BRR(T, 6) = ARR(I, 1)
BRR(T, 7) = ARR(I, 2)
BRR(T, 8) = ARR(I, 17)
BRR(T, 9) = ARR(I, 16)
End If
Next
Sheets("图纸目录").Range("A5:I65536").ClearContents
If T = "" Then MsgBox "没有该日期图纸!": Exit Sub
Sheets("图纸目录").Range("A5").Resize(T, 9) = BRR
End Sub