1,217
社区成员




Sub Macro1()
Range("D2").Select
ActiveCell.FormulaR1C1 = "5/1/2015"
Range("D2:D11").Select
Selection.DataSeries Rowcol:=xlColumns, Type:=xlChronological, Date:= _
xlDay, Step:=1, Trend:=False
Range("E2").Select
ActiveCell.FormulaR1C1 = _
"=IF(ISNA(VLOOKUP(RC[-1],R2C[-4]:R5C[-3],2,FALSE)),0,VLOOKUP(RC[-1],R2C[-4]:R5C[-3],2,FALSE))"
Range("E2:E11").Select
Selection.FillDown
End Sub