I need a excel macro created that i can use to create a csv of options for a shopping cart web site.
This macro needs to be able to generate a list of variations/options based on a list of options provided.
For example, let me explain this a bit more.
This is for a wordpress woocommerce site.
So this is for an product that can either come in its normal paint color, or can be painted.
It has 3 areas that can be painted with 7 or so other colors it can be painted as.
So when i have someone ordering the product, i do not want to allow them to select all of the same areas to be painted, it needs to be one of the 3, 2 of the 3, or 3 of the 3, but they should not be able to select the same areas to be painted.
Like my example above:
Option 1: mag-base-pad
Option 2: mag-base-pad
Option 3: mag-base-pad
I do not want them to be able to select the same for each option.
So how can this be done?
For example, here is a screenshot of how the generator did it - http://screencast.com/t/AURIIeytjhPh