> Michael,
> 
> How do I store the information so as to be able to reference it to the
> correct region?

I'm sorry, I don't understand the question, because I didn't read/remember
the problem description in enough detail. I just saw that it involved
calculating running totals, and gave some general advice on the subject.
Sorry if it didn't take you all the way to a specific solution.

Michael Kay