Results 1 to 5 of 5

Generate list based on product of variables

Threaded View

kareem92 Generate list based on... 02-15-2022, 04:57 AM
AliGW Re: Generate list based on... 02-15-2022, 04:58 AM
XLent Re: Generate list based on... 02-15-2022, 11:42 AM
kareem92 Re: Generate list based on... 02-16-2022, 07:19 AM
kareem92 Re: Generate list based on... 02-16-2022, 07:23 AM
  1. #1
    Registered User
    Join Date
    06-28-2020
    Location
    Riffa Views, Bahrain
    MS-Off Ver
    365
    Posts
    3

    Question Generate list based on product of variables

    Hi All,

    I'm working on mapping the process flows and estimating the expected activity durations at a manufacturing plant.

    I started by listing all the different product variations that would affect the routes and/or durations and came up with this (manually) for one group of products GGC Variations.PNG Variations List.PNG

    Now I need to create another list for a different group of products, that have a total of 6912 variations. See attached BV Variations.PNG

    I don't have any experience with vba but I figured there must be an easier solution than listing each variation manually. Can someone help me out with this please?
    Attached Files Attached Files
    Last edited by kareem92; 02-16-2022 at 07:20 AM. Reason: Solved

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 05-12-2016, 09:29 AM
  2. [SOLVED] VBA to to create a list of product variations based on list of parent products
    By irruzzz in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-12-2016, 08:27 AM
  3. Generate a numerical sku based on product number
    By timmay9162 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-16-2015, 11:18 PM
  4. Generate Product Pick List and transfer to Existing Workbook
    By aaron.meza in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-01-2011, 03:38 PM
  5. Generate List based on specific Variables being Met
    By swankrain in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-04-2010, 04:55 PM
  6. Transfer Data to separate tables based two variables (site and product)
    By yunesm in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-15-2010, 09:47 PM

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