combination macro
Thanks for your help so far. I aplogize for not stating it clearly.
Monday: #1 and subcatogory from 1(a) to 1(f) to be used on Tuesday to Sunday
Tuesday: 2 and subcatogory 2(a) to 2(e) and 1(a) to 1(f)
Wednesday: 3 and subcatogory 3(a) to 3(d), 2(a) to 2(e), and 1(a) to 1(f)
Thursday: 4 and subcatagory 4(a) to 4(c), 3(a) to 3(d), 2(a) to 2(e), and
1(a) to 1(f)
Friday: 5 and subcatagory 5(a) to 6(b), 4(a) to 4(c), 3(a) to 3(d), 2(a) to
2(e), and 1(a) to 1(f)
Sat: 6 and subcatagory 6(a) to 6(a), 5(a) to 6(b), 4(a) to 4(c), 3(a) to
3(d), 2(a) to 2(e), and 1(a) to 1(f)
Sun:7, 6(a) to 6(a), 5(a) to 6(b), 4(a) to 4(c), 3(a) to 3(d), 2(a) to 2(e),
and 1(a) to 1(f)
Rules:
Subcatagory is not to be used for the same day, and each subcatagory can
only be used once in an (a) to (f) order. For example, 1(a) can't be used for
Monday, but it's an option for Tuesday. To be more specific, if I start with
#1 on Monday, on Tuesday, I can pick #1(a) or #2, on Wednesday, I can pick
#3, #2(a), or #1(b), etc.
Is there a way to create a macro to list out all the possible outcome??
Thanks!
|