+ Reply to Thread
Results 1 to 2 of 2

Grouping same rows

  1. #1
    Registered User
    Join Date
    03-31-2008
    Posts
    3

    Grouping same rows

    Hey everyone,

    I'm wondering if anyone would know how to select rows with the same name in column A, i know i can ctrl click them i need to know another way for a macro that i wish to create, it would go something like :
    select "fda" in column A
    copy
    insert into new worksheet

    eg

    A B C
    fda 12 54
    vfd
    vdr
    fda 76 32
    nuj
    ple
    fda 51 90

    many thanks

  2. #2
    Registered User
    Join Date
    03-26-2008
    Posts
    45
    Highlight row 1, then go to Data, then choose Filter, then AutoFilter.
    That will put little drop arrows in your first row and you can filter it to any group you want.

+ 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