Quote:
Originally Posted by KeriM
John,
One more question. How do I get it to loop through all the sets of criteria and put it where I want it to go? For example, I want "a1" to go into cell C3, "a2" to go into cell C4, "b1" to go into cell C8, "b2" to go into cell C9, etc. I can do it with one set of criterion (like "a1"), but how do I combine it with all my criteria?
|
I was able to get it working; however, I ended up just putting each set of values in their own sub and making a big runall() at the top so it just runs through all the subs. Is there a more efficient way?