+ Reply to Thread
Results 1 to 4 of 4

Excel List

  1. #1
    Registered User
    Join Date
    06-06-2013
    Location
    Montgomery, Alabama
    MS-Off Ver
    Excel 2010
    Posts
    2

    Excel List

    Hello all, I'm relatively new to using excel, only the past couple months and most everything I have been able to figure out myself but this one has me stumped. I have a huge client list that I need to only draw about a third of the names from to make a new separate list. Is there anyway to do this short of copying and pasting each name and address individually. The main list is in alphabetical order right now but in terms of sorting, there is no one zip code or city to go by. Any help would be great. Thanks

  2. #2
    Forum Guru tigeravatar's Avatar
    Join Date
    03-25-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2003 - 2013
    Posts
    5,361

    Re: Excel List

    jsdunn23,

    Welcome to the forum!
    How would Excel know which clients from the list you need returned?
    Hope that helps,
    ~tigeravatar

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Registered User
    Join Date
    06-06-2013
    Location
    Montgomery, Alabama
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Excel List

    I don't know. The best I can come up with is going through and highlighting them all and copying and pasting them to a new sheet. Its just that its a couple thousand names and addresses and I wanted to see if there was an easier way.

  4. #4
    Valued Forum Contributor
    Join Date
    07-27-2012
    Location
    Dublin, Ireland
    MS-Off Ver
    Excel 2010
    Posts
    826

    Re: Excel List

    jsdunn23, as tigeravatar is alluding to, if there is nothing special or unique about the clients you want extracted from the list, it will not be possible to give Excel a "rule" by which it will know what ones to extract. If you cannot add, for example, a category field (which may be useful not just now, but in the future too), then you could perhaps save yourself a little effort by highlighting just one field (eg surname) in each client that you want to extract. When that's done, Excel can filter by colour, and you can copy the list in one action, rather than by copying and pasting each client as you go through your list.

    Hope that helps.
    Brendan.


    __________________________________________________________________________________________________
    Things to consider:

    1) You can thank any poster by clicking the * at the left of a helpful post.
    2) You can help to keep the forum tidy by marking your thread as "Solved", if it has been answered to your satisfaction.
    3) Help us to help you, by uploading a sample workbook, showing the type of data you're dealing with, and clearly indicating what the results should be.

+ 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