|
Sub text()
Dim j%, i%, Dic As Object, a, b
Sheet1.Range("A4:A5000").ClearContents
Set Dic = CreateObject("scripting.dictionary")
For i = 2 To Sheet2.Cells(Rows.Count, 2).End(xlUp).Row
a = DateSerial(Year(Date), Sheet1.Range("C2"), Sheet1.Range("D2"))
If Sheet2.Cells(i, 3) = a And Sheet2.Cells(i, 4) = Sheet1.Range("B2") And Not Dic.exists(Sheet2.Cells(i, "F")) Then
' If Not Dic.exists(Sheet2.Cells(i, "F")) Then
Dic(Sheet2.Cells(i, "F").Value) = ""
'End If
End If
Next
Sheet1.Range("A4").Resize(Dic.Count, 1) = WorksheetFunction.Transpose(Dic.keys)
End Sub
|
|