I've lost track of the detail of what you're trying to do at this
point. If you have something that works for you and runs fast enough
don't worry about being more efficient.

On Mon, 20 Aug 2012 20:02:52 +0000, KeriM
wrote:


KeriM;1604763 Wrote:
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?

John Keith