+ Reply to Thread
Results 1 to 4 of 4

vba Copy Filter item and paste at other worksheet

  1. #1
    Registered User
    Join Date
    07-17-2012
    Location
    Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    48

    vba Copy Filter item and paste at other worksheet

    Hi Guys i have a question is there got any coding to allow me to filter the item in the excel sheet and the paste the data into another worksheet?

    Sheet1
    GGG
    AAA
    AAA
    BBB
    CCC
    DDD
    EEE
    DDD
    AAA
    DDD
    FFF
    GGG

    Sheet2
    AAA
    BBB
    CCC
    DDD
    EEE
    FFF
    GGG

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: vba Copy Filter item and paste at other worksheet

    You need to explain some more?

    What do you need filtered?
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Registered User
    Join Date
    07-17-2012
    Location
    Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    48

    Re: vba Copy Filter item and paste at other worksheet

    Hi i want to filter out the repeated value and then paste it on another sheet
    I want to automate this

    Quote Originally Posted by arlu1201 View Post
    You need to explain some more?

    What do you need filtered?

  4. #4
    Forum Contributor bonny24tycoon's Avatar
    Join Date
    04-02-2012
    Location
    Hell
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    405

    Re: vba Copy Filter item and paste at other worksheet

    It would help if you could upload an example workbook, so we could build the macro as per the columns in your example workbook...
    Thanks,

    Bonny Tycoon


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1