Hello All,

Hoping someone can kindly assist with this query.

At present, I am using the following code for extracting unique data (but without any conditions):

Sub CopyUnique()
    Dim s1 As Worksheet, s2 As Worksheet
    Set s1 = Sheets("Sheet2")
    Set s2 = Sheets("Sheet1")
    s1.Range("AB2:AB7000").Copy s2.Range("A3")
    s2.Range("C:C").RemoveDuplicates Columns:=1, Header:=xlNo
End Sub
What I'd also like to be able to do, is still extract the above but only when the values in Sheet1 Column A = Sheet2 $A$1 and Sheet 1 Column K = Sheet 2 $B$1.

Hoping this is possible and that I've appropriately conveyed what I need.

Thanks ever so much for the support.