+ Reply to Thread
Results 1 to 4 of 4

Automatically populate a list based on defined categories -- user input varies

  1. #1
    Registered User
    Join Date
    03-06-2009
    Location
    Minnesota, US
    MS-Off Ver
    Excel 2007
    Posts
    5

    Automatically populate a list based on defined categories -- user input varies

    This is a repost from a previous, unclear thread. Apologies and thanks to Teylyn.

    I'm only interested in user input to the yellow highlighted cells in the "Gang" sheets. I've already entered some generic, but real scenario input where some cells are left blank and appear to be random. Let's assume if that if a tool block has input, then all three cells (part #, description, and type) will have input.

    The goal is to get all of the entries listed on the Tool Summary sheet, based on the category provided (see example of how I prefer the list to display). I'm having a tough time with how to even approach this issue, so any push in the right direction will help (even if this thread belongs elsewhere).


    THANKS IN ADVANCE!
    Attached Files Attached Files
    Last edited by NearClueless; 03-11-2009 at 04:21 PM. Reason: link

  2. #2
    Forum Expert
    Join Date
    01-15-2007
    Location
    Brisbane, Australia
    MS-Off Ver
    2007
    Posts
    6,591

    Re: Automatically populate a list based on defined categories -- user input varies

    Hi

    On your sheet TOOL SUMMARY, change the items in row 4 to be END MILL, DRILL and TAP - ie remove the S so that the heading is the same as the drop down tool type.

    Then run

    Please Login or Register  to view this content.
    See how that goes.

    rylo

  3. #3
    Registered User
    Join Date
    03-06-2009
    Location
    Minnesota, US
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Automatically populate a list based on defined categories -- user input varies

    Quote Originally Posted by rylo View Post
    See how that goes.
    GREAT! The code worked perfectly. There's one small problem -- my understanding of code language. It looks like I have a little homework in front of me. Don't get me wrong, all I asked for was a push in the right direction and you've done exactly that. Many thanks.

    To take this a step further, I have other excel files with the same setup but the sheets aren't named convieniently Gangs 1-4; so the FOR (i = 1 To 4) statement wouldn't apply. Could one still use FOR statement to tabulate throught the sheets, or would one need the WITH statement repeated for each sheet (specifically named)? There would be five sheets max so not a big deal.
    Last edited by NearClueless; 03-12-2009 at 09:21 AM. Reason: text correction

  4. #4
    Forum Expert
    Join Date
    01-15-2007
    Location
    Brisbane, Australia
    MS-Off Ver
    2007
    Posts
    6,591

    Re: Automatically populate a list based on defined categories -- user input varies

    HI

    If your sheets are in a block - say the first 4 sheets - then you could use the same approach but use the sheet index

    Please Login or Register  to view this content.
    This will action the first 4 sheets regardless of their name.

    HTH

    rylo

+ 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