+ Reply to Thread
Results 1 to 3 of 3

Need a way to make selecting an item from a data validation list easier... like AutoFill?

  1. #1
    Forum Contributor Legend Rubber's Avatar
    Join Date
    09-21-2012
    Location
    Tillsonburg, Ontario
    MS-Off Ver
    Excel 2010
    Posts
    392

    Need a way to make selecting an item from a data validation list easier... like AutoFill?

    I have a list that is very long... (200 or so numbers) that i have in a fairly complex packing slip...
    I am looking for a way to make selecting what you need easier...
    I have some other things attached to this, so i dont know if i can use a combobox...
    Check out the attached and see if anyone can help... i would be very thankful....
    So far Packing Slip.xlsm

  2. #2
    Valued Forum Contributor
    Join Date
    03-23-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    1,093

    Re: Need a way to make selecting an item from a data validation list easier... like AutoFi

    Hello there,

    Can you please elaborate on what it is that you are trying to select and once selected where the information should go? Looking at your workbook I'm not sure.

    Thanks!

  3. #3
    Forum Contributor Legend Rubber's Avatar
    Join Date
    09-21-2012
    Location
    Tillsonburg, Ontario
    MS-Off Ver
    Excel 2010
    Posts
    392

    Re: Need a way to make selecting an item from a data validation list easier... like AutoFi

    Cells A20-A45 contain DV drop down lists that once selected automatically insert the corresponding parts and quantities.
    Everything is working pretty much perfectly, but it takes forever to scroll down the list in the drop down...
    i simply wondered whether there was a way to simplify this...

+ 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