List combinations VBA

thank you so much,,i didnt expect such a quick response and solution.

However something is off. bc the final results should have been 1080 total combos.

For aisles 1 and 2 , there are only 2 items to choose from a pool of 4 options:

Result = 6 unique combos. 3!= 3+2+1

For aisles 3 and 4 , there are only 2 items to choose from a pool of 3 options:

Result = 3 unique combos. 2!= 2+1

For aisles 5,6 and 7 , there are only 3 items to choose from a pool of 6 options:

Result = 10 unique combos.

And the most difficult is the remaining items to fill aisles 8 and 9. Since aisles 3 and 4 should be filled it only leaves 1 item left . And for aisles 5,6,7 there should be 3 items left , for a total of 4 items that should not have been previously used.

For aisles 8 and 9 , there are only 2 items to choose from a pool of 4 remaining options:

Result = 6 unique combos. 3!= 3+2+1

So the final tally is 6x3x10x6 = 1080 total results.

I hope this helps,,and again amazing work you have done. Thank you.

Also the lists in each aisle can change on a monthly basis. I hope I will be able to add to or decrease as needed. EX: the list for aisles 1 and 2 could go from 4 this month to only 3 the next.