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.
Bookmarks