Extract List from one sheet to another with Unique Value (2 conditions)

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.

Please Login or Register  to view this content.

please help.

Thanks,

Please see below image.

Extract Column G value with unique value on Column J


Screenshot.jpg

Thank you,

Sorry bakerman2 if that was confusing.

attached is the sample file. I hope you find it simple. My codes back then was unclear.

Please see file attached and modify the codes

It works on your file but I cant figure it out how to apply in my file. I keep getting error.

I need this not in change event.

I can't make the Previous code work either. It says "The command requires at least two rows of data"

Please Login or Register  to view this content.

Below is my filters
Column G = Search Value
Column J = Only with unique value (No Duplicate)

Originally Posted by sunjam

Below is my filters
Column G = Search Value
Column J = Only with unique value (No Duplicate)

try

Please Login or Register  to view this content.

Thanks Jindon,

Can you make it a certain Range and not the entire sheet?

Sheet1 column G:L to Sheet2 column A:F starts from row 2.

Thanks,

Then perhaps

Please Login or Register  to view this content.

works great!

Thanks Jindon!

Hello Jonin,

is it possible to add Column N and P in the copied column?

With Sheets("sheet1").Cells(1).CurrentRegion.Columns("G:L") '---- Add Column N and P


Thank you,

Do you mean

Please Login or Register  to view this content.

?

Exactly!

Thanks Jindon!