vba Unique value with criteria
Results 1 to 1 of 1

Thread: vba Unique value with criteria
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Jul 2012
    Posts
    60
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default vba Unique value with criteria

    Hi friends

    I i need two alteration in below code.

    1:= CriteriaRange:=Sheets("statement").Range("b1:b3")
    2:-formula should be copied in cell (a4) instead of (a1)

    Code:
    Sub unique()
    
    Dim s1 As Worksheet, s2 As Worksheet
        Set s1 = Sheets("csales")
        Set s2 = Sheets("statement")
        s1.Range("a:h").Copy s2.Range("A1")
        s2.Range("a:h").RemoveDuplicates Columns:=1, Header:=xlNo
    End Sub
    Thanks
    Last edited by chunu; Aug 22nd, 2019 at 12:40 PM.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •