+ Reply to Thread
Results 1 to 3 of 3

Create a combination of every option.

  1. #1
    Forum Contributor
    Join Date
    05-05-2004
    MS-Off Ver
    Office 365
    Posts
    571

    Create a combination of every option.

    I am trying to create a list of every potential option for a furniture line.

    Let me explain the attached spreadsheet.

    Col P lists the frames that make the furniture and the numbers in Q represent the prices for those specific frames. You can see that Teak is more expensive than Smoke, as Smoke is more expensive than Silver.

    Col R lists the different cushions that you can pick for the frames with Col S showing the prices for those frames, where again Black is the most expensive option.

    This process will be used for various sets of furniture so the prices, number of frame options and cushion colors WILL vary from set to set.

    So, what does the output look like after you run the macro.

    A1-B19 shows how I will put together the options. You see the formulas used to create that list, obviously the real list is MUCH longer than this but if I can just get the code to start this it can surly be altered to accommodate what I need to do.

    Thank you for your help
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    6,731

    Re: Create a combination of every option.

    Formula for A2

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Formula for B2

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Then select A2:B2 and fill down until all you see are blank cells.
    Please Avoid Joining My List Of Blocked Users by:

    Saying Please and Thank you.

    Making requests not demands.

    Checking back on your post. I will not edit any post after 4 days.

    Marking threads as closed once your issue is resolved. How? The tools at the top

    Any reputation (*) points appreciated. None of us gets paid here.

    If you found someone's input useful, please take a second to click the * at the bottom left to let them know

  3. #3
    Forum Contributor
    Join Date
    05-05-2004
    MS-Off Ver
    Office 365
    Posts
    571

    Re: Create a combination of every option.

    Thank you!

+ 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