I have a code below that will extract rows from worksheet "Loan Search" to worksheet "ILQ" with criteria on column G.
The Need:
I would like to add a criteria that would extract only those with unique values in Column J.
There will be 2 conditions, criteria on Column G and unique values in Column J.
Dim iRowSearch As Integer
Dim iRowWrite As Integer
iRowWrite = 3
iRowSearch = Worksheets("ILQ").Cells(Rows.Count, "A").End(xlUp).Row
iRowSearch = Worksheets("ILQ").Cells(Rows.Count, "B").End(xlUp).Row
iRowSearch = Worksheets("ILQ").Cells(Rows.Count, "C").End(xlUp).Row
iRowSearch = Worksheets("ILQ").Cells(Rows.Count, "D").End(xlUp).Row
iRowSearch = Worksheets("ILQ").Cells(Rows.Count, "E").End(xlUp).Row
iRowSearch = Worksheets("ILQ").Cells(Rows.Count, "F").End(xlUp).Row
iRowSearch = Worksheets("ILQ").Cells(Rows.Count, "G").End(xlUp).Row
iRowSearch = Worksheets("ILQ").Cells(Rows.Count, "H").End(xlUp).Row
For iRowSearch = 2 To Worksheets("Loan Search").Cells(Rows.Count, "G").End(xlUp).Row
If Worksheets("Loan Search").Cells(iRowSearch, "G").Value = Range("ILQ_LN").Value Then
Worksheets("ILQ").Cells(iRowWrite, "a").Value = Worksheets("Loan Search").Cells(iRowSearch, "g").Value
Worksheets("ILQ").Cells(iRowWrite, "b").Value = Worksheets("Loan Search").Cells(iRowSearch, "h").Value
Worksheets("ILQ").Cells(iRowWrite, "c").Value = Worksheets("Loan Search").Cells(iRowSearch, "i").Value
Worksheets("ILQ").Cells(iRowWrite, "d").Value = Worksheets("Loan Search").Cells(iRowSearch, "j").Value
Worksheets("ILQ").Cells(iRowWrite, "e").Value = Worksheets("Loan Search").Cells(iRowSearch, "k").Value
Worksheets("ILQ").Cells(iRowWrite, "f").Value = Worksheets("Loan Search").Cells(iRowSearch, "l").Value
Worksheets("ILQ").Cells(iRowWrite, "g").Value = Worksheets("Loan Search").Cells(iRowSearch, "n").Value
Worksheets("ILQ").Cells(iRowWrite, "h").Value = Worksheets("Loan Search").Cells(iRowSearch, "q").Value
iRowWrite = iRowWrite + 1
End If
Next iRowSearch
please help.
Thanks,
Bookmarks