+ Reply to Thread
Results 1 to 7 of 7

alphabetic list - copy each letter to different worksheet

  1. #1
    Forum Contributor
    Join Date
    03-24-2009
    Location
    Vietnam
    MS-Off Ver
    Excel 2010
    Posts
    381

    alphabetic list - copy each letter to different worksheet

    Hi!

    I have a list with approx. 60.000 entries (one per row) and one empty row after each letter. Eg:

    Adam
    Albert
    Aston
    <empty row>
    Barbara
    Barbie
    Busty
    <empty row>
    Charles
    ...

    Now, what I would need to do is to cut the rows of all entries which start with the same letter and paste them into a worksheet named after the respective letter (e.g "A", "B", "C", etc.).
    Well, since this work is a little tiring, I was hoping that someone could help me with a macro who does that simple work for me, please

    Every help is highly appreciated!
    Thanks a lot,
    A2k

  2. #2
    Valued Forum Contributor JeanRage's Avatar
    Join Date
    03-02-2009
    Location
    Nice, France
    MS-Off Ver
    Excel 2003
    Posts
    705

    Re: alphabetic list - copy each letter to different worksheet

    Hi,

    Have you tried, with a small sample, to turn on your macro recorder to start building your own macro ...?

    HTH

  3. #3
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,167

    Re: alphabetic list - copy each letter to different worksheet

    Assume list of names is in column A of active sheet. A1 needs to contain a field header.

    A1: =Names
    A2: =Adam
    A3: =Albert
    etc

    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info

  4. #4
    Forum Contributor
    Join Date
    03-24-2009
    Location
    Vietnam
    MS-Off Ver
    Excel 2010
    Posts
    381

    Re: alphabetic list - copy each letter to different worksheet

    Thanks for the help andy!

    However, this is almost what I need. Instead of just copying the first cell (A1), could you make it copy the whole row?
    I tried to adjust the code but failed miserably

    Thanks!
    A2k

  5. #5
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,167

    Re: alphabetic list - copy each letter to different worksheet

    just change the copy method to include the entirerow

    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    07-17-2010
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    1

    Re: alphabetic list - copy each letter to different worksheet

    Hello,

    How this macro can works with number?
    If the table
    A1. 12
    A2. 56
    A3. 67

    Max id 100 and make new sheet with id number

    Thanks

  7. #7
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: alphabetic list - copy each letter to different worksheet

    Welcome to the forum.

    Please take a few minutes to read the forum rules, and then start your own thread.

    Thanks.
    Entia non sunt multiplicanda sine necessitate

+ 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