Results 1 to 18 of 18

Adding Preset Data to Template with Lists

Threaded View

  1. #1
    Forum Contributor amyxkatexx's Avatar
    Join Date
    11-23-2009
    Location
    Chattanooga, TN
    MS-Off Ver
    Excel 2004 for Mac
    Posts
    128

    Adding Preset Data to Template with Lists

    Okay, so I have a spreadsheet that has nearly 15,000 brands on column A and their appropriate brand keys on column B. It is rather annoying having to go to this every time I need to find a brand key and I would like to make a list of the brands so that I can choose from the appropriate one and then the cell to the right automatically matches that brand to the appropriate brand key.

    I figured I could use AutoFilter and some formulas to do this, but it would take forever to scroll through the thousands of brands to get to one that starts with a letter like Z.

    I thought about having multiple AutoFilter lists, one for each letter of the alphabet, but that would just take up too much space and even if I did, there are over 2,000 brands that start with the letter M alone.

    I don't know if there is a setting in AutoFilter that enables you to search within the list by typing or something of that nature, or if there is something else besides AutoFilter that would do the job instead, but I just need an easier way of sorting through this list of brands.

    Any ideas?
    Last edited by amyxkatexx; 03-09-2010 at 12:44 PM. Reason: Changed Title

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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