Create a combination of every option.

[sungen99]

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

[mehmetcik]

Formula for A2

Please Login or Register  to view this content.

Formula for B2

Please Login or Register  to view this content.

Then select A2:B2 and fill down until all you see are blank cells.

[sungen99]

Thank you!